/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

0 vote364 views1 answer
Laravel collection shift
PHP
3 votes294 views3 answers
Wordpress logout
PHP
7 votes388 views5 answers
Laravel if else condition in blade file
PHP Laravel
10 votes308 views4 answers
Twig dump
PHP
5 votes336 views1 answer
Php 8.1 release date
PHP
2 votes348 views1 answer
Laravel vendor:publish not working
PHP Laravel
0 vote359 views1 answer
Rest api response 404 wordpress
PHP Wordpress
4 votes306 views2 answers
Laravel sum column values
PHP
0 vote300 views1 answer
Php artisan queue start
PHP Laravel
1 vote315 views1 answer
Laravel order by raw
PHP