/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 vote143 views1 answer
Regex to remove span tags using php [duplicate] codegrepper
PHP
0 vote173 views2 answers
How to back the page laravel where the scorll is
PHP Laravel
0 vote157 views1 answer
Get user type wp php
PHP
1 vote187 views1 answer
Laravel end date greater than start date validation
PHP Laravel
0 vote110 views1 answer
Laravel collection tap
PHP
0 vote139 views1 answer
Composer packages
PHP
0 vote147 views1 answer
Get deleted value laravel
PHP
0 vote232 views2 answers
Multiple image upload with CodeIgniter
PHP CodeIgniter
0 vote143 views6 answers
Create symfony project
PHP
3 votes256 views6 answers
Jwt laravel
PHP Laravel