/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

2 votes228 views1 answer
Livewire not working
PHP
-3 votes228 views2 answers
How to set up alert messages in laravel 8
PHP Laravel
17 votes256 views6 answers
Php sha256
PHP
0 vote210 views1 answer
Take and skip in laravel
PHP
21 votes224 views2 answers
Php delete element by value
PHP
0 vote220 views1 answer
Drupal 9 custom access checking for routes
PHP
0 vote215 views1 answer
Php conditionally remove element from array
PHP
-1 vote228 views1 answer
Laravel get fetch api request body
PHP
7 votes212 views3 answers
Php round to whole number
PHP
1 vote218 views1 answer
Mb_strtolower
PHP