/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 vote123 views2 answers
Laravel eloquent update multiple records
PHP Laravel
0 vote93 views1 answer
Provenienza geografica di un utente php webmaster
PHP
0 vote99 views1 answer
How to add javascript to a php file
PHP
0 vote100 views1 answer
Undefined type excel
PHP
0 vote113 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel
0 vote126 views1 answer
Wordpress change email new user template
PHP Wordpress
1 vote133 views4 answers
Codeigniter where_not_in
PHP CodeIgniter
0 vote133 views2 answers
Get http referer php
PHP
4 votes214 views6 answers
How to remove index.php in codeigniter
PHP CodeIgniter
0 vote81 views1 answer
Appserviceprovider laravel share common settings for all controllers
PHP Laravel