/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 vote256 views2 answers
Laravel migration table softdeletes
PHP
0 vote253 views2 answers
Php loop backwards through array
PHP
0 vote268 views1 answer
Image not save laravel
PHP
0 vote268 views1 answer
Radio button select in php
PHP
0 vote311 views2 answers
Wordpress admin redirecting to http
PHP Wordpress
7 votes249 views1 answer
Php configuration
PHP
4 votes264 views1 answer
Php reading a file line by line
PHP
0 vote268 views4 answers
Laravel old value for select option
PHP
1 vote285 views5 answers
Laravel modules
PHP Laravel
0 vote314 views1 answer
Install sass laravel
PHP Laravel