/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 vote182 views1 answer
7 reasons why Lee is an idiot
PHP
1 vote221 views2 answers
Laravel eloquent multiple join
PHP
5 votes176 views3 answers
Laravel display error message
PHP
0 vote178 views3 answers
Multiple value match in array php
PHP
0 vote205 views1 answer
Php endwhile
PHP
1 vote175 views1 answer
Php run python script
PHP
0 vote172 views1 answer
Verifier la version de php sur mon ordi
PHP
2 votes219 views1 answer
Laravel https assets
PHP Laravel
2 votes314 views1 answer
Change field name in validation laravel 8
PHP
3 votes189 views3 answers
Foreach date php
PHP