/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

8 votes163 views3 answers
Connect php to db
PHP
0 vote161 views1 answer
Add brackets to string php
PHP
0 vote171 views1 answer
Woocommerce pagination
PHP
0 vote288 views2 answers
Http://www.finalclap.com/faq/81-php-afficher-date-heure-francais
PHP
0 vote109 views1 answer
Register column types octobercms
PHP
0 vote213 views1 answer
Laravel log query for model (full)
PHP Laravel
0 vote221 views1 answer
Laravel 8 db like query
PHP Laravel
11 votes172 views6 answers
Convert object to array in php
PHP
0 vote155 views2 answers
How to check if username already exists in php
PHP
1 vote124 views10 answers
Loop object by value php
PHP