/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

4 votes351 views2 answers
Php read file line by line
PHP
1 vote367 views1 answer
[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.
PHP
0 vote378 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
15 votes335 views3 answers
Delete file in php
PHP
1 vote323 views1 answer
Laravel roles
PHP
0 vote338 views1 answer
Php inline if condition date time
PHP
2 votes393 views1 answer
Laravel model truncate
PHP Laravel
0 vote325 views1 answer
Php version not update after windows env file
PHP
0 vote315 views1 answer
Show data as per url slug change in laravel
PHP
0 vote327 views1 answer
Create email template php
PHP