/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 vote161 views1 answer
Php radian to cosine
PHP
2 votes196 views1 answer
Debug query in moodle
PHP
0 vote206 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
6 votes169 views4 answers
Laravel blade foreach index value
PHP
22 votes159 views6 answers
Laravel log
PHP Laravel
1 vote146 views1 answer
Php artisan migrate could not find driver
PHP
2 votes173 views3 answers
Laravel Create Custom Artisan Command
PHP
12 votes178 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
1 vote188 views1 answer
Group_concat laravel
PHP Laravel
7 votes138 views1 answer
Php set no memory limit
PHP