/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

6 votes129 views3 answers
Php request uri
PHP
12 votes150 views3 answers
Do_shortcode
PHP
12 votes123 views6 answers
Php remove new line character from string
PHP
0 vote142 views2 answers
Check if number is multiple of 3 in php
PHP
1 vote147 views3 answers
Php convert special characters to normal
PHP
35 votes204 views6 answers
Php format date
PHP
9 votes153 views6 answers
Get raw query laravel
PHP Laravel
1 vote159 views2 answers
Get unique values in laravel
PHP Laravel
0 vote149 views1 answer
Laravel where false
PHP
1 vote131 views2 answers
Laravel route group middleware prefix
PHP