How can I use this Mysql statement in Mysqli?

Question

How can I use this Mysql statement in Mysqli?

Navigation

#1 by (0 votes)

0

Since the old versions of php are no longer supported, I am migrating my projects to MYSQLI and I have a problem, I do not know how to group them in an array, since my previous code was this:

$enero = mysql_fetch_array(mysql_query("SELECT SUM(kg_panela) AS r FROM dia_batido WHERE MONTH(fecha)=1 AND YEAR(fecha)='$año'"));

Any help please.

mysql php mysqli

asked by Luis Suárez 16.11.2017 в 02:01

source

1 answer

Fill table with json Pass data from firebase firestore to React JS library "react-table"

score 0 · Answer 1

I would do something like this:

$conexion = mysqli_connect('localhost','root','','basededatos');

$sql = "SELECT SUM(kg_panela) AS r FROM dia_batido WHERE MONTH(fecha)=1 AND YEAR(fecha)='$año'";

$query = mysqli_query($conexion, $sql);

$enero = mysqli_fetch_array($query);