/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

25 votes283 views6 answers
Laravel use cache
PHP
3 votes333 views1 answer
Laravel loop through collection
PHP Laravel
0 vote318 views3 answers
Php mvc example
PHP
1 vote301 views3 answers
Laravel eloquent to array key value
PHP Laravel
0 vote246 views1 answer
Laravel access storage attachment
PHP
2 votes314 views3 answers
Laravel url with parameters blade
PHP Laravel
0 vote297 views1 answer
Php object into nested json object
PHP
0 vote278 views1 answer
Laravel easy form
PHP
0 vote322 views1 answer
Use s3 storage laravel
PHP Laravel
63 votes398 views6 answers
Laravel clear cache
PHP Laravel