Questions tagged [mysqli]
The mysqli PHP extension is a PHP database driver. Not to be confused with MySQL database.
mysqli
24,670
questions
-1
votes
0
answers
30
views
Can't output json_encode with PHP7.3 [duplicate]
Finally upgrading from PHP5.5 to PHP7.3 and in PHP5.5 this code works:
$con=mysql_connect("localhost","user","password");
mysql_select_db("database",$con);
$sql ...
- 33
-4
votes
0
answers
38
views
SQLI - Do a select criteria on a field as if there is a string added to it [closed]
Database contains products table
Some users have there own article id's with another prefix.
Lets say prefix YYY.
I thought a query like underneath would give a match:
SELECT * FROM products WHERE &...
- 89
-2
votes
0
answers
31
views
i want to show three tier MLM Tree but it is not showing properly [closed]
I have a three-tier MLM tree with four levels: Basic, Gold, Silver, and Bronze. Gold, Silver, and Bronze are parallel to the Basic level. Every third member added under anyone becomes a Gold member.
...
0
votes
0
answers
17
views
MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received [migrated]
I am trying to do mysql replication. But I want to while the backup is being uploaded to the slave server, the changes in the master are not received.
For example:
I have a user table on my X db. And ...
-2
votes
0
answers
24
views
Insert null in INTEGER COLUMN in mysql [duplicate]
In my mysql database we have few nullable integer and date columns.
Earlier we used to enter blank string ('') in these columns when no data was there and it used to insert properly. But not sure ...
-3
votes
0
answers
45
views
PHP login code will not proceed past $result = mysqli_query($conn, $sql); [closed]
im trying to create a login page for my website and I am trying to just get the function to work but the code wont make it any further than $result = mysqli_query($conn, $sql); and i dont understand ...
-1
votes
0
answers
14
views
mysql->fetch_assoc() not working as per expected [duplicate]
""
Fatal error: Uncaught ArgumentCountError: mysqli_query() expects at least 2 arguments, 1 given in C:\xampp\htdocs\finca-raffledraw\save_winner.php:17
Stack trace:
#0 C:\xampp\htdocs\...
- 1
-1
votes
1
answer
72
views
AJAX Call is not returning any data [duplicate]
I am trying to create a dependency for a project, the SQL query works and returns the data I need in PHP Admin however when I try to create the AJAX request for this all it does is return an empty ...
0
votes
0
answers
15
views
lamp and google cloud [duplicate]
I have deployed a lamp solution on google cloud. The apache server, the ssh connection and the static ip work. Whentrying to connect to phpmyadmin though, i get this error: See error here (it says ...
- 1
0
votes
1
answer
53
views
Mysql/html how to get output like this, or similar
PhpMyAdmin
Looking for output like this:
In Mysql/PHP, how can I get output like this, or similar (photo 2)?
$start = mysqli_query($conn, $sql);
if (mysqli_num_rows($start) > 0) {
$row = ...
- 19
-1
votes
0
answers
48
views
PHP 8 migration with simple script but no errors, just blank white page
I have been using the following custom code for over 12 years and it has worked perfectly. With PHP 8 I just get a blank white page with no errors. It allows me to use template files, so I can keep ...
- 11
0
votes
0
answers
28
views
Cant Insert Data into MySQL Database Using PHP [duplicate]
I'm facing an issue where my PHP script is not successfully inserting data into my MySQL database. Here's my code:
<?php
$conn = new mysqli('localhost', 'cjheller0', 'password', 'user_form_db');
$...
- 1
-1
votes
0
answers
18
views
Rollback does not do anything when error occurs in my transaction mysql [duplicate]
I have written code to insert multiple rows in a table. If there is an error on any of them, I want them to rollback.
The code is written in PHP:
mysqli_report(MYSQLI_REPORT_ERROR | ...
- 65
-3
votes
0
answers
52
views
PHP mysqli_connect does not continue after error [duplicate]
I am very puzzled on using the mysqli_connect() and mysqli_connect_error() in my PHP. I don't know where to look for the problem or how to solve, is it php.ini or my.ini config? Need help.
I am ...
- 35
-1
votes
0
answers
23
views
creating a keyord tag list from a comma seperated list with PHP Mysqli [duplicate]
I have a list of keywords in a database field called "keywords", that I turn into a keyword list to display on a blog as cloud type tags.
//KEYWORD TAG MANUFACURE
$keywordtags="$...
- 57