/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 vote287 views1 answer
Why laravel need to compile assets
PHP
0 vote352 views1 answer
Replicating claims as headers is deprecated and will removed from v4.0. Please manually set the header if you need it replicated.",
PHP
2 votes387 views1 answer
Laravel model truncate
PHP Laravel
0 vote344 views1 answer
Php ungleich
PHP
3 votes339 views2 answers
Cannot create an instance of class viewmodel
PHP
0 vote315 views1 answer
Laravel query builder select first
PHP
0 vote343 views1 answer
CAPTURAR URL PHP
PHP
3 votes308 views1 answer
Php docs
PHP
2 votes326 views2 answers
Phpmailer with laravel
PHP
1 vote336 views1 answer
Php get next saturday
PHP