/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

7 votes343 views6 answers
Get current route laravel
PHP Laravel
0 vote306 views1 answer
Codeigniter update or create
PHP
0 vote323 views1 answer
Comment supprimer balise script hmtl en php regex
PHP
3 votes303 views5 answers
Implode and explode in php
PHP
0 vote294 views2 answers
PHP $argv echo with number of words
PHP
0 vote352 views1 answer
Wordpress 404 page after migration
PHP Wordpress
1 vote292 views1 answer
Print url in view yii2
PHP
75 votes340 views6 answers
Php display errors
PHP
0 vote288 views1 answer
How do i implement blockchain payments on laravel website
PHP
1 vote334 views1 answer
Php convert hex to rgba
PHP