/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

48 votes267 views2 answers
Laravel check my laravel version
PHP
0 vote312 views1 answer
Laravel access storage attachment
PHP Laravel
5 votes279 views3 answers
Globals in php
PHP
1 vote357 views1 answer
Add checkbox in server side datatable laravel
PHP Laravel
0 vote422 views1 answer
Relationship on the base of condition in laravel
PHP Laravel
0 vote293 views1 answer
Filter child table data from parent laravel eloquent
PHP Laravel
0 vote308 views1 answer
Symfony 5 - Customize Twig error templates
PHP Symfony
0 vote292 views1 answer
Throws php
PHP
0 vote302 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
6 votes301 views3 answers
Write Multi-Line Strings in PHP
PHP