/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 vote230 views1 answer
Reset wp query
PHP
1 vote236 views1 answer
Ubuntu fopen failed to open stream: Permission denied
PHP
0 vote174 views1 answer
Php header open pdf in browser
PHP
1 vote251 views2 answers
Serialization of 'Symfony\Component\HttpFoundation\File\File' is not allowed
PHP
0 vote264 views1 answer
Elementor woo product hide add to cart
PHP
3 votes233 views1 answer
Collection empty laravel
PHP Laravel
0 vote234 views3 answers
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1
PHP
0 vote224 views1 answer
Set border phpoffice phpexcel
PHP
1 vote264 views1 answer
Rtl file manager laravel
PHP Laravel
0 vote199 views2 answers
Send data using ajax in laravel
PHP Laravel