/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

-2 votes209 views1 answer
Export html table data to excel in php
PHP
0 vote177 views2 answers
File_get_contents url fail
PHP
0 vote172 views1 answer
How to sort with array and after print by for loop in php
PHP
0 vote246 views1 answer
Comment supprimer le fil d’Ariane WooCommerce dans WordPress
PHP Wordpress
0 vote197 views1 answer
Wp_query first post
PHP
0 vote189 views2 answers
If product open display this button
PHP
1 vote215 views1 answer
How to insert multiple data at a time with create method in laravel
PHP Laravel
2 votes189 views2 answers
Wordpress is admin
PHP Wordpress
1 vote169 views1 answer
Laravel log path
PHP
0 vote238 views1 answer
How to set timezone for iran in laravel
PHP Laravel