PHP MYSQLi Displaying all tables in a database

MySQL
How do I display out all the information in a database (All tables and records) using PHP? I read displaying tables as HTML table but how do I do it f...
1 year ago

How to group continuous ranges using MySQL

MySQL
I have a table that contains categories, dates and rates. Each category can have different rates for different dates, one category can have only one r...
1 year ago

connecting to a docker-compose mysql container denies access but docker running same image does not

MySQL
I am having some issues connecting to the mysql docker container that I have launched with docker-compose. This is a long post (sorry!). Here is my d...
1 year ago

Insert into table cannot be done PHP/mySQL

MySQL
I want to insert values into a database table but for some reason it cannot be done.I checked the code millions of times but it is impossible to find ...
1 year ago

MySQL not returning null column joined value

MySQL
I have these 4 tables: My expected result: this my current query (helped from here) select a.No_Registrasi, a.Nama_CTKI, b.Nama_Negara, CONCAT('...
1 year ago

Combine two Mysql SUM select query to one query

MySQL
I have below two query's SUM the values Query1:* SELECT SUM(price) FROM TABLE1 WHERE acc_id = '555' Query2: SELECT SUM(price) FROM TABLE...
1 year ago

What is the MAX number if I store int(255) in MySQL?

MySQL
I use int(255) in mysql as my id. Is this long enough? If I got about 1,000,000 records....Thank you.
1 year ago

LIKE... AND NOT... sql

MySQL
I am creating a query in which i am selecting data from multiple tables, however, i do not want to select the entry that my users are currently viewin...
1 year ago

Automated database restore from *.sql files

MySQL
I am trying to write a python script with which to restore our database. We store all our tables (individually) in the repository. Since typing "sourc...
1 year ago

GROUP BY in a Multiple SELECT

MySQL
Say I have four tables with the same format: Registered | Score ---------------------- 0 | 10 1 | 5 1 | 7 0 ...
1 year ago

Error when update the tables with PHP

MySQL
this is the problem `You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to us...
1 year ago

show record in between field in mysql not using sub query

MySQL
i want the field nilai_kredit to top at between filed nilai_kredit, if the acct_no is same, but i don't want to use sub query because is slowly SELEC...
1 year ago

MySQL Ignoring Specific Rows?

MySQL
I am running a SQL query to obtain results with the column applicationstatus that aren't S to tell which position is still open. There are 3 applicati...
1 year ago

How to loop the query in this case?

MySQL
I have been trying to loop this query but all I get is the first value. When I do the same command in workbench I get all the values. What am I doing...
1 year ago

how to insert multiple values with foreach

MySQL
adding checkbox values using foreach. the checkbox name are same.. i tried this <?php // checkbox name is check[] $check = $_POST['check']; for...
1 year ago

How to find gaps in sequential numbering in mysql?

MySQL
We have a database with a table whose values were imported from another system. There is an auto-increment column, and there are no duplicate values, ...
1 year ago

How to count the mysql results of 2 tables that have similar conditions?

MySQL
I want to insert into the goals column of the pivot_data the count of 2 tables in total. I can make it work with 1 table, but I am not able to combin...
1 year ago

Count how many rows you have in your db with PHP

MySQL
Hellow, I want to count how many rows i have in a table. I got a table (workstations) in my mysql database (phpmyadmin). I want to print it out, so ...
1 year ago

MySQL SELECT on Arabic Word returns 0 results on PHP but does on SQLBuddy/phpMyAdmin

MySQL
Problem I am getting 0 results when searching for an Arabic word in a MySQL database using the SELECT query with PHP. However, the same exact query...
1 year ago

Count item across multiple columns in same table

MySQL
I have a table that looks like below TableA ------------------------------------ id| ColumnA | ColumnB | ColumnC ----------------------------...
1 year ago