Questions tagged as 'mysqli'

Tagged questions
0
answers

Help with creating ABC curve in Mysql

I mounted a select to know how many products sold in a given period and the sales value of these products. I need to mount an ABC curve with the result of this select. Someone could help me please. My select looks like this: SELECT DI...
asked by 01.04.2018 / 23:50
0
answers

How to feed highcharts with myqsl data?

I'm trying to create a graph using Mysql and Highcharts, but I'm having trouble, I need to replace morris with highcharts, the bar graph, follow php code; function fazerScriptChartArea($dataIni, $dataFim) { global $conn2; require_once...
asked by 06.05.2018 / 23:34
1
answer

Doubt about the error "Strict standards: Only variables should be passed by reference in"

To write some dates in the database in the desired format I'm doing this: mysqli_stmt_bind_param ( $stmt, 's', date("Y-m-d", strtotime($data)) ); Or, to get the current day simply: mysqli_stmt_bind_param...
asked by 22.10.2015 / 19:38
1
answer

Query between Mysql dates showing every day of the range

Hello, I would like help with logic. I have an ecommerce system in which N products are sold and I am comparing the sales of a certain product per period of time, ie the admin will have an area in which he chooses a product and a date range (...
asked by 27.04.2018 / 03:37
1
answer

Failed to register NULL value in database - PHP7

Good night everyone, I'm a beginner and I'm developing a CATEGORY and SUBCATEGORY registration system in PHP7 and MYSQL; The logic I used to register for Categories and Subcategories is: All PAI CATEGORY is null and any subcategory has a v...
asked by 13.11.2017 / 00:13
4
answers

MySQLi vs PDO - Which is the most recommended to use?

With mysql_* entering the deprecated state, the PHP documentation recommends using the PDO and MySQLi. Which do you recommend for use? PDO seems to be more suitable for working with object-oriented only than at the same time I saw...
asked by 06.03.2014 / 18:10
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
1
answer

Help to convert from mysql to mysqli

I'm a little bit lazy in PHP and MYSQL, and I'm having an issue needing help converting the connection in MYSQL to MYSQLI follow the codes below: mysql.php <?php Class mysql { public $query; public $fetchAll; public $resu...
asked by 04.06.2016 / 16:05
0
answers

Help with procedural MySQLi class migration to object-oriented

Hello, good afternoon. I started migrating a MySQLi class of procedural to Object Oriented and two functions of this class left me in doubt. During the migration of the fetchRow and fetch_array functions I was struck by a strong doubt,...
asked by 23.11.2015 / 20:21
2
answers

Mysqli multi_query INSERT + insert_id multiple tables autoincrement + Foreign key

I have 2 tables for example a table "users" containing a primary key ID user and another table "details" with a foreign key do usuario.ID My need would be through php to do for example in a single query the user's INSERT and i...
asked by 07.10.2015 / 21:55