/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 vote141 views1 answer
How to reduce time taken by php script on server
PHP
0 vote135 views1 answer
Check if data inserted in database wordpress plugin
PHP
8 votes160 views1 answer
The best way to learn php
PHP
0 vote145 views1 answer
How to add in massive php
PHP
12 votes247 views3 answers
Validation.required laravel
PHP Laravel
0 vote164 views1 answer
How to Add Custom Navigation Menus in WordPress Themes
PHP Wordpress
1 vote146 views2 answers
Laravel view with data in blade
PHP
0 vote155 views1 answer
Wordpress disable posts
PHP
0 vote137 views3 answers
Count with left join in laravel
PHP
0 vote217 views1 answer
Raw query in laravel with parameters
PHP