/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 vote237 views1 answer
Php header deny
PHP
0 vote193 views1 answer
How to show image from php
PHP
0 vote224 views1 answer
Call to a member function delete() on null laravel 8
PHP Laravel
2 votes176 views2 answers
Laravel validate form data unique
PHP
0 vote185 views1 answer
Apt-get install php wordpress extensions
PHP Wordpress
0 vote185 views1 answer
Wordpress check if class exists
PHP Wordpress
7 votes210 views4 answers
Laravel chunk
PHP Laravel
1 vote248 views1 answer
Laravel-cors
PHP Laravel
104 votes566 views6 answers
Array_push in php
PHP
0 vote243 views3 answers
CONTACT FORM SQL
PHP