/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 vote315 views3 answers
Import faker in laravel
PHP Laravel
26 votes245 views2 answers
Php artisan clear commands
PHP
0 vote237 views1 answer
Red rose
PHP
0 vote299 views1 answer
Laravel where on relationsship column
PHP Laravel
0 vote241 views2 answers
Php loop backwards through array
PHP
11 votes241 views6 answers
How to print on python
PHP
0 vote294 views1 answer
Laravel eloquent update quantity
PHP Laravel
0 vote219 views2 answers
How to replace multiple characters in a string in php
PHP
0 vote255 views1 answer
Seeder name singular or plural laravel
PHP
0 vote245 views1 answer
Livewire call another component
PHP