/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

-1 vote145 views1 answer
Add method to laravel blade
PHP Laravel
0 vote128 views1 answer
Php script auf serve alle 5 minuten ausführen
PHP
0 vote159 views1 answer
Store image to s3 laravel
PHP Laravel
0 vote180 views1 answer
Laravel joins eloquent model
PHP
0 vote130 views1 answer
Drupal 8 entity query
PHP
0 vote151 views2 answers
Cannot modify header information - headers already sent by
PHP
7 votes175 views3 answers
Laravel seed migrate
PHP Laravel
3 votes135 views1 answer
Drop table phpmyadmin
PHP
17 votes134 views3 answers
Php print_r array
PHP
0 vote130 views1 answer
Laravel blade array seearch select box
PHP