/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 vote115 views1 answer
Php unix socket client
PHP
4 votes115 views2 answers
Define home url wp
PHP Wordpress
0 vote129 views1 answer
Laravel compare request domain and app domain and request original domain
PHP Laravel
2 votes101 views1 answer
Append new line php
PHP
5 votes134 views2 answers
Laravel naming conventions
PHP Laravel
9 votes115 views3 answers
Php variable as javascript function parameter in echo
PHP
2 votes129 views1 answer
Webpack font awesome
PHP
0 vote149 views1 answer
Laravel get fillable attributes
PHP Laravel
0 vote125 views1 answer
If name value contains space in php
PHP
1 vote110 views2 answers
Download pdf php
PHP