/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

10 votes158 views2 answers
Php get keys and values from array
PHP
2 votes163 views1 answer
Delete confirmation destroy laravel
PHP
0 vote144 views1 answer
Header return back php
PHP
2 votes162 views2 answers
Php pdo rowcount
PHP
0 vote173 views1 answer
Menampilkan hari dan tanggal sekarang di php
PHP
7 votes174 views3 answers
How to show validation error in laravel blade
PHP
4 votes173 views7 answers
Convert a String to a Number in PHP
PHP
1 vote182 views1 answer
Laravel eloquent where id not equal to
PHP Laravel
7 votes196 views3 answers
Laravel seed migrate
PHP Laravel
7 votes162 views5 answers
Laravel if else condition in blade file
PHP