/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 vote153 views1 answer
Laravel asset resolving to http not https
PHP Laravel
2 votes163 views3 answers
Laravel 8 404 status
PHP
0 vote141 views1 answer
Laravel 6 use username on url
PHP
30 votes131 views6 answers
Laravel auth
PHP
0 vote181 views1 answer
Referencing constant in config laravel
PHP Laravel
1 vote186 views1 answer
Wordpress echo the excerpt
PHP Wordpress
0 vote131 views1 answer
Php hide credit card middle numbers
PHP
20 votes166 views4 answers
Pretty dump
PHP
2 votes188 views1 answer
Php shuffle array
PHP
0 vote132 views1 answer
Laravel faker boolean
PHP