/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 vote131 views1 answer
Php get first digit of number
PHP
0 vote140 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
2 votes122 views2 answers
How get the first item in foreach in laravel
PHP
10 votes141 views3 answers
Check count in laravel
PHP Laravel
0 vote128 views1 answer
Migrate only one table laravel
PHP
2 votes117 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP
-1 vote118 views1 answer
Where is phpinfo()
PHP
10 votes114 views6 answers
Php array_filter
PHP
3 votes134 views2 answers
How to add values to an array in laravel
PHP Laravel
0 vote135 views1 answer
Create new controller laravel with model binding
PHP Laravel