MySQL Forums - PHP

AWS Ubuntu / MariaDB / MySQL can't view tables but data looks like it's there (no replies)

Christopher Feeny — Tue, 24 Feb 2026 21:58:32 +0000

Recently my phpBB forums stopped working with DB errors, I tried to go and view the tables and nothing returns. I went to the /lib/ mysql directory and the DB directory is there and full of the files many very large, but I cannot access them.

I also get authentication errors now. I have root/ownership of the domain.

Ubuntu is the latest LTS release.

Can someone help?

Failed connection or timeout to remote MySQL server takes web sites offline (no replies)

Paul Field — Wed, 12 Nov 2025 21:02:01 +0000

I have a Linux web server that contains a number of websites in PHP.

A few of the sites do queries to a remove MySQL server, some of the sites use local MySQL, and most don't use any MySQL at all.

Whenever the remote MySQL server can't be reached, it quickly stops all the sites on the server from responding.

Is there any config to stop the other sites from being dragged down by the sites trying to do the remote queries?

I'm assuming this is all because there is a query queue somewhere on the local server that fills up and something dies.

When the remote MySQL server comes back online, everything catches up in a few minutes and all the sites come back online too.

Thanks

PHP version change (no replies)

Familiar IT — Mon, 28 Oct 2024 00:42:21 +0000

PHP version changes introduce new features, improvements, and security enhancements, while deprecating outdated functions. Upgrading ensures better performance and compatibility with modern frameworks, but may require code adjustments for deprecated elements to maintain functionality.

Php database connect error (no replies)

IFTIKHAR AHMAD — Mon, 26 Aug 2024 15:38:29 +0000

Hello everyone:
I am getting following error on MySQL 5.4 Windows server 2012;

A PHP Error was encountered
Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Connection refused

Filename: mysqli/mysqli_driver.php

Line Number: 202

Backtrace:

File: /var/www/vhosts/sys.lhc.gov.pk/htdoc/application/controllers/Case_management.php
Line: 37
Function: __construct

File: /var/www/vhosts/sys.lhc.gov.pk/htdoc/index.php
Line: 315
Function: require_once

A Database Error Occurred
Unable to connect to your database server using the provided settings.

Filename: controllers/Case_management.php

Line Number: 37

An expert response is highly appreciated

SQL Search Help (no replies)

B R — Sun, 04 Aug 2024 06:31:20 +0000

I have a table of players and a table called gamePlayers. In this table I have a row for each game (which has gameID) key, and playerID for each player in each game.

I have a player in question, their unique field is playerID

What I want to do is show the a count of other players who've played in the same same game as the player in question.

For example, player 20 in question, player 30 is in 10 games the same as player 20.

how can I do this?

SQL Query (1 reply)

Mammaluk Luk — Thu, 12 Dec 2024 13:23:00 +0000

Hi everyone, sorry but I translate from Italian with Google. I hope my question is clear.
We have provided a database in SQL. at the moment the sistem owner told me that it is not possible to extract data. I believe instead that since there is a "relationship" it can be done. example:
(12345678) A (bin name)
(REF 12345678) B
(REF 12345678) C
(REF 12345678) D
(REF 12345678) E
documents contained in the binder.
can you extract A and below all the REFs with that number? Thanks for the reply

Convert database string (2 replies)

Gerd Modla — Tue, 06 Aug 2024 13:43:47 +0000

Hello
I'm trying to read some data from my database. So far it's worked without any problems. Now I want a read array, which looks like this...

Array ( [0] => 25.88 [1] => 25.88 [2] => 25.88 [3] => 26.00 [4] => 25.81 [5] => 25.88 [6] => 25.75 [7] => 25.94 [8] => 25.69 [9] => 25.69 [10] => 25.62 [11] => 25.62 [12] => 25.75 )

into a readable format for my Javascript.

The format must look like this...

25.88, 25.88, 25.88, 26.00, 25.81, 25.88, 25.75, 25.94, 25.69, 25.69, 25.62, 25.62, 25.75

My script sees this...

-------------------------------------------

//Database access data
$hostname = "localhost:3306"; // eg,localhost - should not be empty for productive servers
$password = "xxxxxxxx"; // The password of the database
$username = "web705"; // The username of the database
$usertable = "wp"; // Database table name that gets created by setup
$database = "web705"; // Database where Online search records are held

// Connection to DB
$db_conn = mysqli_connect ($hostname, $username, $password, $database);

// Variable for DB array
$i = 0;

// Read the DB
$sql = "SELECT * FROM wp ORDER BY DT DESC LIMIT 13";

//Checks connection and reads data from DB
$db_query = mysqli_query( $db_conn, $sql );
if ( ! $db_query )
{
die('Invalid query: ' . mysqli_error());
}

while ($row = mysqli_fetch_array( $db_query, MYSQLI_ASSOC))
{
echo $row['t1'];
echo ", ";

$string1[$i] = $row["t1"];
$string2[$i] = $row["t2"];
$i++;
}

mysqli_free_result( $db_query );

echo "

";
print_r($string1);

?>

------------------------------------------------------------

CREATE TABLE `wp` (
`ID` int(11) UNSIGNED NOT NULL,
`DT` timestamp NOT NULL DEFAULT current_timestamp(),
`DATE` date NOT NULL DEFAULT current_timestamp(),
`TIME` time NOT NULL DEFAULT current_timestamp(),
`t1` decimal(6,2) DEFAULT 0.00,
`t2` decimal(6,2) DEFAULT 0.00,
`t3` decimal(6,2) DEFAULT 0.00,
`t4` decimal(6,2) DEFAULT 0.00,
`t5` decimal(6,2) DEFAULT 0.00,
`t6` decimal(6,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Data for table `wp`
--

INSERT INTO `wp` (`ID`, `DT`, `DATE`, `TIME`, `t1`, `t2`, `t3`, `t4`, `t5`, `t6`) VALUES
(1, '2024-06-03 10:55:01', '2024-06-03', '12:55:01', 25.00, 24.75, 0.00, 0.00, 0.00, 0.00),
(2, '2024-06-03 11:00:00', '2024-06-03', '13:00:00', 25.12, 24.88, 0.00, 0.00, 0.00, 0.00),
(3, '2024-06-03 11:05:01', '2024-06-03', '13:05:01', 25.06, 24.81, 0.00, 0.00, 0.00, 0.00),
(4, '2024-06-03 11:10:01', '2024-06-03', '13:10:01', 25.19, 25.00, 0.00, 0.00, 0.00, 0.00),
(5, '2024-06-03 11:15:01', '2024-06-03', '13:15:01', 25.31, 25.06, 0.00, 0.00, 0.00, 0.00)

-----------------------------------------------------------------

The PHP version is 8.0.23 !

I have to insert the string like this in Java...

Can someone please change the script so that it works?

best regards...

MYSQL mysqli_num_rows vs Select count() (no replies)

Rasly Sameen — Thu, 02 May 2024 10:49:22 +0000

I am currently working on optimizing our database queries and came across two options that perform the same task get row count. but might have varying levels of efficiency. I was hoping you could shed some light on which one would be faster and more effective in terms of performance.

Option 1:
$query = "SELECT * FROM tb";
$q = mysqli_query($conn, $query);
$row = mysqli_num_rows($q);

Option 2:
$query = "SELECT count(id) as num FROM tb";
$q = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($q);

SQL hacking (no replies)

chuck lidderdale — Mon, 04 Mar 2024 19:37:51 +0000

I have a problem. I have a web page with a "join.php" subpage. Someone has found a way to POST to the page making it look like they have filled in the form and hit "Submit". They have included their name "SEFUSHWWDSDF" and their address "1247 FKHSFH" and an email ie "laurenwade30@gmail.com".

I'm guessing: just for the "L" of it, being allowed to post spam to a group, whatever ...

Suggestion on how to cut this SOB off at the knees. Thanks

More CPU Usage (no replies)

Srinivas Pokala — Wed, 28 Feb 2024 08:39:51 +0000

HI
I am getting more cpu usage at heavy traffic.

Online users 600 requests per sec
Max. concurrent connections 2400
Almost 8000 select queries per seconds

Configuration values:

innodb buffer pool size: 85GB
thread_cache_size=500;
read_buffer_size=6291456;
max_connections=2500;
innodb_print_all_deadlocks=ON;
innodb_io_capacity=1000;
innodb_lru_scan_depth=100;
innodb_flush_neighbors=2;
innodb_max_dirty_pages_pct_lwm=1;
innodb_max_dirty_pages_pct=1;
innodb_change_buffer_max_size=50;
sort_buffer_size=8388608;
range_optimizer_max_mem_size=16777216;
innodb_flush_log_at_trx_commit=2;
key_cache_age_threshold=7200;
key_cache_block_size=16384;
key_cache_division_limit=50;
join_buffer_size=3145728;
table_open_cache=9216;
binlog_expire_logs_seconds=259200;
log_queries_not_using_indexes=OFF;
slow_query_log =OFF;
key_buffer_size=268435456;
log_error_verbosity=1;
read_rnd_buffer_size=1048576;

Whatever queries we are using with index and joins executed in 0.005 seconds maximum, but the same queries take over 20 seconds when more users are online.

Please suggest to need any changes in MySQL values

Thanks
Srinivas

requête sql avec SUM ? (2 replies)

Guillaume Daudet — Fri, 15 Dec 2023 20:06:55 +0000

Bonjour à tous,
Je ne suis pas débutant en php, ni avec mysql, mais j'ai pas mal perdu depuis environ 10 ans ( raison médicale, peu importe .. )

J'ai besoin d'un coup de pouce pour ce type de requête:

$sql = 'SELECT year,visits, SUM(visits) FROM stats WHERE year=$year ORDER BY year ';
[ en gros, il me faut connaître le nombre de visites / an sur mon site.. ]
Et J'ai des colonnes "années /mois/ visits )

Merci d'avance pour votre aide et vos lumières !
Guillaume.

Feedback on a free PHP code security scanner in beta (4 replies)

Theo Grant — Mon, 04 Dec 2023 09:22:09 +0000

Hey everyone!

My name is Theo and my team and I have recently finished working on quite a big project that's currently in beta. It's a PHP code security scanner and we are asking programmers who's code of choice happens to include PHP to maybeee check it out and give us some feedback so we could improve it?

It's a win-win cause you get a free & comprehensive tool to scan your PHP code for vulnerabilities and we get feedback from people like us but with a fresh pair of eyes!

Idk if this message would be considered spam if I attached a link though so I'm going to post this first and see if any mods get back to me aha. All I want is some feedback but for some reason my posts get flagged as spam if they include links :(

Anyway, would anyone be interested in something like this?

I'm searching for where the data is, in a php driven website. (no replies)

C Scheppers — Tue, 31 Oct 2023 02:37:17 +0000

Hi, I was handed a website to maintain, such as update pictures and text. I have access to the website's control panel, source files, ftp privilege, etc. The website is written in php.

I have been searching for where the data is located and think it is in a mysql format. Every webpage source I examine just calls another php page, which calls another php page, which calls another php page, etc.

The website is fully functional, no code problems. But there are a few sentences that need changing and I still haven't found the location of the sentences.

I am still digging through the php scripts being called and will have some code examples to post that seem to be pretty standard calls I have found elsewhere on the internet.

I do perl, javascript and html so this environment is new to me.

Thanks

How to track DB changes automatoacally (no replies)

Shanthini G — Tue, 17 Oct 2023 09:30:35 +0000

How can we track the changes that we do in database structure. Curranty we are manually maintaining the sql in a file that we do in our local and are executing them while moving to production. Thanks

critical error when updating wordpress (2 replies)

Ahmet Tuter — Thu, 27 Jul 2023 08:38:47 +0000

I was trying to update my wordpress to latest version on my wordpress site but it now just displays an empty screen and says there has been a critical error on website. what can be the reason and how to solve? luckily i saved backups before updating but prefer to solve the problem without deleting the entire files and db and reloading

PHP Uncaught mysqli_sql_exception: Access denied for user (1 reply)

Louis at oracle — Wed, 29 Mar 2023 13:43:38 +0000

I try to run an apache webserver on an Ubuntu 22.04 LTS server.

I installed mysql (8.0.32), php (8.1.2) and apache2. I manage the mysql instance remotely via mysql workbench on a windows machine

The MySQL has a DB which I can configure locally and via the workbench;
I defined an user for the DB which has mysql access via the ubuntu commandline via mysql -u user -p

In mysqld I changed the listening addresses:
# bind-address = 127.0.0.1
bind-address = 127.0.0.1,192.168.x.y
# mysqlx-bind-address is for the X plugin
mysqlx-bind-address = 127.0.0.1,192.168.x.y

I connect to the DB using php like this
$host = 'localhost'; // "127.0.0.1"
// $username = "mr_x"; // new pas type
$username = 'mr_y'; // old pw type
$password = '';
$dbname = 'some_db';

try {
// Establish connection to database use mysqli
//$mysqli = new mysqli("localhost", "username", "password", "databaseName");
$conn = new mysqli($host,$username,$password,$dbname);
$conn->set_charset('utf8mb4');

This SHOULD imho work ... however it does not ...

PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'mr_y'@'localhost' (using password: YES) in /var/www/etc.

I have tried all kind of options to fix this issue even temporarily installing php8.2 (ubuntu is running in an VM), which did not solve the problem. So I did revert to the formal 8.1 version

Given all the effort I put in trying to solve the problem ...
I Sincerely hope any one has a clue / knows how to fix this !!

Mysql Gone Away Error (1 reply)

tayfun gulr — Thu, 23 Feb 2023 20:28:55 +0000

Hello,

I updated mysql 5.7 to mysql 8. I am getting "Mysql Gone Away" error. I didn't change any configuration. What should I do?

A single user registration breaks registration/login system but how? (2 replies)

Paul Maher — Wed, 05 Apr 2023 08:09:48 +0000

Short version ... sign/up login system in PHP/MySQL suddenly stopped working/failing silently no php errors in logs, nothing.

After check after check I decided to look at the database, I don't what made me do it, a hunch I suppose, I removed the last user that registered from the user table in DB. Low and behold signup/login are working again.

Can anyone shed any light on what this could be? I need to make sure this does not happen again and I am stumped right now as to what the exact cause is...

schematisation relation entre tables sql (no replies)

Manuel Baranger — Sat, 14 Jan 2023 09:32:33 +0000

Bonjour à tous,

je m'initie à la manipulation de phpmyadmin et j'essaie de créer des relations entre différentes tables, mais je ne sais pas si je m'y prend bien...

Mon organisation a établir est la suivante :

J'ai des medecins qui sont, soit indépendants (travaillant seuls), soit des medecins faisant parti d'un cabinet médical.
Pour chaque médecin, je dois associer des "catégories" qui sont :
- coordonnées
-infos diverses
-consignes

Voici donc ma propre logique pour la création des relations des tables :

Table "medecins" contient deux tables ("independants" et "cabinet médical")

La où je bloque, c'est la suite des relations car je ne sais pas comment relié les tables "infos", "consignes" et "coordonnées"

Quelqu'un saurait il me dire ou me conseiller sur ce qui serait le plus pratique svp ?

Merci

php script for join, using group by based on user input (no replies)

Rebecca Hudson — Thu, 01 Dec 2022 20:31:19 +0000

I have been trying for a couple days to get my code to group by a StockCode and list all of the associated alternates. I get the listing and can use the variable inputs from users to pull up what is needed but visually it can be hard to look at since the stock code is listed repeatedly for each alternate part associated with the StockCode.

When I tried to perform a group by in workbench to test the script it gives me a 1055 error. Can someone help. My query code snippet is below.

$result = mysqli_query($con,"SELECT
qadb.cm_dbo_invmaster.StockCode, qadb.cm_dbo_invmaster.Description, qadb.cm_dbo_mfr_mfrpn.ManufacturerName, qadb.cm_dbo_mfr_mfrpn.ManPartNumber, qadb.cm_dbo_mfr_mfrpn.CageCode
FROM qadb.cm_dbo_invmaster INNER JOIN qadb.cm_dbo_mfr_mfrpn
ON qadb.cm_dbo_invmaster.StockCode = qadb.cm_dbo_mfr_mfrpn.StockCode
WHERE qadb.cm_dbo_invmaster.StockCode Like '".$NumberCriteria."'
AND qadb.cm_dbo_invmaster.Description Like '".$DescriptionCriteria."'
GROUP BY qadb.cm_dbo_invmaster.StockCode
ORDER BY qadb.cm_dbo_invmaster.StockCode");

The Query works until I put in the Group By Statement.

Can anyone help me with this Query? (no replies)

DR Rom — Thu, 10 Nov 2022 17:12:21 +0000

Basically my goal is to have a multiple filter in my small project that I'm working.
I have a page for Rooms or Lobby.

Filters are:

Privacy : ( 0 / 1 / 2 ) 0 = All / 1 = Public / 2 = Private

Status : ( 0 / 1 / 2 / 3 ) 0 = ALl / 1 = Open / 2 = In Progress / 3 = Completed

Created By Me: ( True or False )

Joined Room: ( True or False )

I also have 2 tables.. One for Rooms and other for Room_users

| User ID | Name |
| -------- | -------- |
| 1 | Me |
| 2 | Raven |
| 3 | Gabby |

| Room ID | Title | Privacy | Status | User ID |
| -------- | ----------- | -------- | -------- | ---------- |
| 1 | My Room | 1 | 1 | 1 | <<< Me/I'm the Creator/Host
| 2 | Raven Room | 2 | 1 | 2 | <<< Raven is the Creator/Host
| 3 | Gabs Room | 1 | 1 | 2 | <<< Raven is the Creator/Host

| Room Users | Room ID | User ID | Status |
| ---------- | ---------- | -------- | -------- |
| 1 | 2 | 1 | 1 |
| 2 | 2 | 3 | 2 |
| 3 | 3 | 3 | 1 |

Here, Me and UserID#3 joined to Room ID#2 (Raven Room)

**Status**: 1 = Pending / 2 = Joined

The result should display, Rooms based on the filter..
Here's my current query:

$userID = My ID / UserID# 1

$status = ($status != "0") ? "AND `a`.`status` = '".$status."'" : "AND `a`.`status` != '0'";
$privacy = ($privacy != "0") ? "AND `a`.`privacy` = '". $privacy ."'" : "AND `a`.`privacy` != '0'";

"SELECT a.room_id, a.title, a.status, a.privacy, a.user_id, b.room_id, b.user_id, b.status, c.user_id, c.name
FROM `rooms` as `a`
LEFT JOIN `room_users` as `b` ON `a`.`room_id` = `b`.`room_id`
LEFT JOIN `user` as `c` ON `b`.`user_id` = `c`.`user_id`
WHERE (`a`.`user_id` = '". $userID ."' OR (`b`.`status` != '1' OR `b`.`user_id` = '". $userID ."')) ". $status ." ". $privacy ." ORDER BY `a`.`room_id` DESC"

When i filter Privacy: All, it should return this ff:
1. all rooms that is public
2. all rooms that I'm member of (Private). Else, it should be exluded.

Filter: Privacy: Public should only display all rooms with status 1 (Public)

Filter: Privacy: Private should only display all rooms that **I'm member of**.

when I filter Created By Me, it should display only rooms that I created.

when I filter Joined Room, it should display only the rooms that I'm member of.

Right now, according to my query it only returns room that I joined in and the room I created.

And it displays multiple duplicated rooms, but I used array_unique to return only the unique rooms. I CAN'T use **GROUP BY** since it has a problem with MySQL regarding sql_mode=only_full_group_by and for some reason I dont have access on doing that.

Can anyone help me with how to construct the query for the database, so it will return the accurate data that i needed..

Any help is very much appreaciated.

Will the size of a Postgres database's uuid index be smaller than that of MySQL or InnoDB? (no replies)

Pawan Kumar — Thu, 03 Nov 2022 05:34:54 +0000

Will the size of an index on an uuid column in Postgres be less than it is in MySQL / InnoDB?

INSERTING RECORDS INTO MULTIPLE TABLES (1 reply)

Sunday Olaoye — Tue, 06 Sep 2022 19:23:14 +0000

I was trying to insert records into multiple tables in one file. The first two queries ran very well but the third one did not run. The first table is normal table while the last 2 tables are cross-reference tables, which store primary keys of two tables each. Here is the code snippets for your help:

// initialize prepared statement
$stmt = $con->stmt_init();

$insert_product = "INSERT INTO products (cat_id, manufacturer_id,date,product_title,product_url,product_img1,product_img2,product_img3,product_price,product_keywords,product_desc,product_features,product_video,seo_keywords,product_label,product_sale ) VALUES(?, ?, NOW(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
// bind parameters and execute statement
if ($stmt->prepare($insert_product)) {
// bind parameters and execute statement
$stmt->bind_param('iisssssisssssss', $cat, $manufacturer_id, $product_title, $product_url,$product_img1,$product_img2,$product_img3,$product_price,$product_keywords,$product_desc,$product_features,$product_video, $product_seo,$product_label,$product_sale );
$stmt->execute();
if ($stmt->affected_rows > 0) {
echo "";
}
}

// if the product entry was inserted successfully, check for sizes
if (($stmt->affected_rows > 0) && isset($_POST['size'])) {
// get the product's primary key
$product_id = $stmt->insert_id;
foreach ($_POST['size'] as $size_id) {
if (is_numeric($size_id)) {
$values[] = "($product_id, " . (int) $size_id . ')';
}
}
if ($values) {
$sql = 'INSERT INTO product2size (product_id, size_id) VALUES ' . implode(',', $values);
// execute the query and get error message if it fails
if (!$con->query($sql)) {
$sizeError = $con->error;
}
}
}

// third query
// if the product entry was inserted successfully, check for product categories

if (!isset($sizeError) && isset($_POST['product_cat'])) {
// get the product's primary key, my issue is this , the last query is parallel to this one, that is why I am still putting last insert id of product table and is not working
$product_id = $stmt->insert_id;
foreach ($_POST['product_cat'] as $p_cat_id) {
if (is_numeric($p_cat_id)) {
$values[] = "($product_id, " . (int) $p_cat_id . ')';
}
}
if ($values) {
$sql = 'INSERT INTO product2pcat (product_id, p_cat_id) VALUES ' . implode(',', $values);
// execute the query and get error message if it fails
if (!$con->query($sql)) {
$pcatError = $con->error;
}
}
}

My problem is that I wouldn’t know what I will put where I put last insert Id in the third query since, it does not depend on the previous cross reference table.

where statement with OR matching placeholder (1 reply)

Paul Maher — Wed, 24 Aug 2022 05:23:46 +0000

Hello,

what is correct syntax for matching either one of two values to a single URL parameter using placeholder with OR in WHERE clause?

WHERE (col1 = ? OR col2 = ?)

WHERE (col1 OR col2) = ?

thanks

Echo date in dd-mm--yy format (4 replies)

Sean Schaffer — Fri, 19 Aug 2022 16:02:21 +0000

I searched for a similar question in this forum but didn't see it. I apologize if asked previously. I am echoing into a table a date that is in "dd-MM-yyyy hh:mm:ss" format from a column called "date_added" in my db, but I need to echo it in dd-MM-yy.

I found some info on maybe using strtotime() to format but I'm confused as to where to put the formatting info. The piece of code that echos the date is below.

echo "" . $row["date_added"]. "

Any help is appreciated.

PHP Mail (4 replies)

Parker Shannon — Fri, 29 Jul 2022 12:21:29 +0000

I cobbled an email script together and it's been running fine, but all of a sudden Gmail and AOL mail are dumping my stuff into spam folders.

These are my headers:

$headers .= "From: " . "\r\n";
$headers .= "Reply-To: \r\n";
$headers .= "Return-Path: \r\n";
$headers .= "X-Priority: 3\r\n";
$headers .= "X-Mailer: PHP". phpversion(7.4) ."\r\n" ;

Is there any code that can get around those damned filters.

I'm grateful for your wisdom . . .

suggest Best CMS for ecommerce website (1 reply)

Gulshan Negi — Fri, 22 Jul 2022 09:06:36 +0000

Hello everyone, I want to create an e-commerce website for my offline computer store, as everyone knows that the world is moving to digital very rapidly. and nowadays most of the small and medium organizations moving online to serve their Product and their services to the maximum number of people, please suggest me which is the best e-commerce CMS for e-commerce,(Shopify, woo-commerce, Drupal, Magento, open cart), please suggest wich one is best.

Thank You.

undefined function mysqli_result() (1 reply)

Kon Kom — Tue, 12 Jul 2022 14:15:43 +0000

Hello I have problem and error:
Fatal error: Uncaught Error: Call to undefined function mysqli_result() in C:\xampp\htdocs\unity\odczytDanych.php:13 Stack trace: #0 {main} thrown in C:\xampp\htdocs\unity\odczytDanych.php on line 13

code:

$tabela = $_POST['tabela'];
$gracz = $_POST['gracz'];
$zmiennaIN = $_POST['zmienna'];

$con = mysqli_connect("localhost","root","") or ("Blad polaczenia: " . mysqli_error());
if (!$con)
die('Nie mozna polaczayc: ' . mysqli_error());

mysqli_select_db($con, "konta") or die ("Nie mozna wczytac bazy danych" . mysqli_error());

$zmiennaOUT = mysqli_result(mysqli_query($con, "SELECT '".$zmiennaIN."' FROM '".$tabela."' WHERE login='".$gracz."'"),0);
die ($zmiennaOUT);

?>

PHP FRAMEWORK (1 reply)

palak sharma — Sat, 25 Jun 2022 10:10:32 +0000

Hi, this is Palak Sharma.
I am in final year of my engineering and after completion of third year I had taken course of PHP programming language. And now I have started coding in PHP but I need you people support to know that on which PHP framework I should work, can you guys give me your suggestions on that.
I am waiting for some positive response.
Thanks

Query grows slower as user activity increases (1 reply)

Jayshree Yeolekar — Thu, 02 Jun 2022 15:53:25 +0000

PHP Version: 7.3.19
mysql version: 10.4.13 (Maria DB)
I am running an application on Linux, using PHP and Mysql. We have multiple queries which runs perfectly fine when 20-25 people are using the application. But when the users are more than 30 users the query becomes very slow. there are more than 500 users which want to use this application. If one of the query takes 0.188844 seconds to execute, but when there are many users attempting to do the same activity at the same time, the processes becomes very slow and takes about 21.017460seconds to execute sometimes even more.

below is some of examples from slow query log:
===============# Time: 220601 7:42:44
# User@Host: root[root] @ WIN-MN0PM3TE06L [10.15.51.252]
# Thread_id: 41274 Schema: mahabhumi_prod8 QC_hit: No
# Query_time: 0.188844 Lock_time: 0.000154 Rows_sent: 0 Rows_examined: 51848
# Rows_affected: 0 Bytes_sent: 10337
SET timestamp=1654049564;
SELECT *
FROM (`kcc_requests`)
WHERE `aadhar_num` = 'XXXXX';

===============# Time: 220601 14:12:13
# User@Host: root[root] @ WIN-MUQCJ3KLLE2 [10.15.51.250]
# Thread_id: 81466 Schema: mahabhumi_prod8 QC_hit: No
# Query_time: 21.017460 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 52692
# Rows_affected: 0 Bytes_sent: 10337
SET timestamp=1654072933;
SELECT *
FROM (`kcc_requests`)
WHERE `aadhar_num` = 'YYYYY';
=================