i have a project looks like this. i want to view picture then want to write something about this picture. the “gönder” button should effect the right above picture. i want to add these to …
Tag: phpmyadmin
mysql query dynamic update
RESOLVED I have a mysql table (table1) with many columns with a single ID. table name: table1 columns: from “pt1 to pt1000” id = 1 I have a query that updates the data in the columns, 10 data at a time I would need a unique and dynamic query that inserts the 10 values in sequence at each submiss…
“a symbol name was expected” error trying to create a table in phpMyAdmin
I am trying to create a table in a database in phpMyAdmin and I keep getting the “a symbol name was expected” error and I cannot figure out what is going on. Is my syntax wrong? I am new to this and I’m at a loss. Answer Column names, table names should be surrounded by backticks(“) Or…
phpmyadmin 403 Forbidden after php downgrade from 7.4 -> 7.3 on CentOS 7 Apache
I have acquired VPS and got it with LAMP. I installed phpmyadmin and configured it’s phpmyadmin.conf file to make it accessible from browser and it was working. Later I upgraded my PHP 5.x to 7.4. version following this tutorial: https://computingforgeeks.com/how-to-install-php-7-4-on-centos-7/ After up…
How to get values from phpmyadmin with the same datetime?
I am building a mini-portal/website and I need to select values with the same DateTime. For example, the first three values have the same DateTime and I would like to select them, yet I don’t know how …
Copy rows in MySQL table multiple times and adding additional column
I have created MySQL table in database. Table name is products and the columns are( prodict_id(pk) product_name and pack_size) as shown in the figure below. What I want to do is , copy all the rows …
How to solve this issue of sql query to work perfectly?
I have a database that I have made on phpmyAdmin. I have and issue that Page is showing ERROR: Could not able to execute SELECT * FROM employees. But it seems that I have done everything perfectly, …
(Laravel) Change Nova Resource name? (only on interface)
I’m trying to change the display name of one Nova resource, without change the name from de database that it references. Only for View / interface purposes. I checked the AppNova*myResource*.php file and find this variable: But after change this the same old name still appears. Anyone knows how to resol…
Fatal error: Query Failed! SQL: SELECT * INTO OUTFILE
I couldn’t understand why a query work as expected in PhpMyAdmin and from command line (mysql client) and not in PHP. Fatal error: Query Failed! SQL: SELECT * INTO OUTFILE ‘/var/www/html/domain.dom/tmp/qry_patients_11_11.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘…
pass the tablename to getData.php in flutter
I am making a flutter application using MySQL. In the home page I have a listview as shown below. The database has unique tables for each item in the list view. What I want is that when I am calling …