/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

37 votes139 views6 answers
Laravel order by
PHP Laravel
0 vote126 views2 answers
Current url wordpress
PHP Wordpress
8 votes139 views5 answers
Laravel belongs to
PHP
0 vote279 views1 answer
Warning: require(C:\xampp\htdocs\ilsa\phpapiboatekapp\public/../vendor/autoload.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ilsa\phpapiboatekapp\public\index.php on line 34
PHP
0 vote100 views1 answer
Foreach ($objects as $obj){ echo $obj->user->description; }
PHP
2 votes131 views3 answers
Laravel fortify
PHP Laravel
1 vote114 views1 answer
Php filter name
PHP
1 vote100 views1 answer
Visual studio php dollar sign double click
PHP
0 vote123 views2 answers
Loop foreach laravel with number
PHP Laravel
19 votes108 views5 answers
Php check string
PHP