/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 vote118 views1 answer
Use of segment in laravel 8
PHP Laravel
4 votes93 views2 answers
Get session blade
PHP
0 vote87 views1 answer
Install the php_mysql extensions
PHP
1 vote102 views2 answers
Strtotime format
PHP
2 votes186 views1 answer
Find word in text in laravel
PHP Laravel
2 votes95 views3 answers
How to change the colum type in migration laravel
PHP
8 votes101 views3 answers
Validate time in laravel
PHP
1 vote97 views2 answers
Define multiple variables in one line php
PHP
0 vote95 views1 answer
Get shipping price of choosen shipping method woocommerce
PHP
2 votes97 views1 answer
Php split string at first space
PHP