/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

3 votes216 views3 answers
Laravel notification
PHP Laravel
1 vote144 views1 answer
Wp query search
PHP
1 vote189 views1 answer
Bin to dec php
PHP
6 votes221 views2 answers
Laravel findorfail
PHP Laravel
9 votes174 views3 answers
Pdo close connection
PHP
1 vote188 views1 answer
Php check name
PHP
35 votes173 views6 answers
For php
PHP
0 vote185 views1 answer
Array_merge_recursive in php
PHP
0 vote192 views1 answer
Pagination javascript php
PHP
18 votes205 views3 answers
Laravel blade for loop
PHP