/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 vote266 views1 answer
How to get a list of registered route paths in Laravel?
PHP Laravel
0 vote229 views1 answer
Hint extension in visual studio code for laravel
PHP
0 vote231 views1 answer
Laravel Http client throw exception if request is not successful
PHP
1 vote219 views1 answer
Laravel read file from tmp
PHP
0 vote222 views1 answer
Laravel collection zip
PHP
7 votes232 views4 answers
Php check string is int
PHP
53 votes225 views2 answers
Transforming string to integer in php
PHP
3 votes237 views1 answer
Laravel e commerce full project
PHP
0 vote236 views1 answer
How to concatenate folder name with image in php
PHP
28 votes248 views5 answers
Migrate specific table laravel
PHP