/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 vote119 views4 answers
Laravel form request validation api
PHP
2 votes112 views5 answers
Laravel installation in windows
PHP
0 vote118 views2 answers
Php get last modified date of file
PHP
0 vote125 views1 answer
Failed opening required 'PHPMailer\PHPMailer\PHPMailer'
PHP
4 votes120 views4 answers
Wp enqueue styles
PHP Wordpress
-1 vote103 views1 answer
Connect to ftp server php
PHP
11 votes113 views4 answers
Check php version
PHP
0 vote128 views1 answer
Wordpresss loop through object
PHP Wordpress
5 votes144 views3 answers
Globals in php
PHP
6 votes122 views1 answer
Laravel route param blade
PHP