/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 vote175 views1 answer
Laravel fetch max value
PHP
12 votes159 views3 answers
Uninstall php ubuntu
PHP
0 vote171 views3 answers
CONTACT FORM SQL
PHP
2 votes175 views1 answer
Base64 encode laravel
PHP
0 vote171 views1 answer
Laravel create registration bootstrap
PHP
0 vote183 views1 answer
Wc php retrieve the order Id on Order pay page
PHP
4 votes170 views2 answers
Laravel migration table column nullable
PHP
6 votes179 views5 answers
Laravel disable cors
PHP Laravel
4 votes174 views4 answers
Php timestamp
PHP
-2 votes180 views2 answers
Upgrade php 5.6 to 7 centos 7
PHP