/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

1 vote208 views2 answers
Php check if associative array
PHP
9 votes209 views3 answers
PHP Numbers
PHP
0 vote199 views1 answer
Who is known as the father of PHP?
PHP
12 votes206 views3 answers
How to log object laravel logger
PHP
6 votes212 views6 answers
Php mysql connection
PHP
0 vote195 views1 answer
Php array extract value
PHP
11 votes190 views3 answers
Laravel running a specific migration on different path
PHP
10 votes292 views4 answers
Laravel migration change column default
PHP Laravel
0 vote213 views1 answer
Laravel denny request by ip
PHP
3 votes200 views1 answer
Cannot use object of type App\ViewModels\Admin\Category\Category ViewModels as array (View: C:\OSPanel\domains\megaimkon.loc\resources\views\admin\category\index.blade.php)
PHP