/PHP/Connecting to database and performing sql queries

Connecting to database and performing sql queries

<?php 
//Connecting to the database
$conn =  mysqli_connect('localhost', 'root', '', 'peroHub');

if(!$conn){
    echo "Error in connection: " . mysqli_connect_error();
}

$sql = 'SELECT title, ingredients, id FROM pizzas';

$result = mysqli_query($conn, $sql);


$pizza = mysqli_fetch_all($result, MYSQLI_ASSOC);

//free result from memory
mysqli_free_result($result);

//close connection
mysqli_close($conn);

// print_r($pizza);


?>

Source: stackoverflow.com

Similar codes

2 votes340 views1 answer
Install composer without requirement
PHP
0 vote357 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
2 votes360 views1 answer
Laravel instal
PHP Laravel
14 votes334 views3 answers
Log facade laravel
PHP
2 votes369 views2 answers
Laravel migration add unique column
PHP Laravel
0 vote360 views4 answers
Laravel collection contains
PHP Laravel
0 vote326 views1 answer
Yii2 OAuth2
PHP
12 votes310 views3 answers
Uninstall php ubuntu
PHP
0 vote306 views1 answer
Php hour between
PHP
0 vote304 views1 answer
Show float laravel blade
PHP