/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

3 votes187 views3 answers
Php remove everything after character
PHP
0 vote230 views1 answer
Https://ols.liu.edu.lb/mod/quiz/rview.php
PHP
0 vote183 views1 answer
Small rce php
PHP
15 votes280 views6 answers
Add shortcode in wordpress
PHP
5 votes185 views6 answers
Get current month php
PHP
0 vote221 views1 answer
Laravel doesn't work update
PHP Laravel
0 vote185 views1 answer
Singular from table laravel
PHP
0 vote211 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP
10 votes221 views2 answers
Same password check in laravel
PHP Laravel
0 vote219 views1 answer
Twig superglobal post
PHP