I am using jquery ajax to call up a PHP page simple API that returns JSON. here is the code for that <?php $response['is_error'] = 'no'; $user = $_POST['user']; $date = $_POST['date']; $sql = "select * from locations where user_id='$user'…
I am using phpMyAdmin and I have been trying to store input images directly on phpMyAdmin as a LARGEBLOB type. However, it doesn't upload properly and I have encountered errors such as "Fatal error: Allowed memory size of 134217728 bytes…
I want to insert the value of my hidden file input into my database but I'm unsure how. My code just keeps inserting blank values to my database, but I want to insert the filename that's being uploaded. This is…
I developed an application connected to mariaDB (Ver 15.1 Distrib 10.1.31-MariaDB, for Win32) in DelphiXE8. I want to improve query performance. Describe the simplified scenario: de_User Table (innoDB) (rows 81762) ID_U INT PRIMARY KEY Name VARCHAR(30) INDEX ID_U, Name de_doc…
I am creating a Java application that communicates with MySQL database. Using XAMPP 5.6.33-0 and phpMyAdmin. I have the following method that, among other values, inserts a Timestamp into the table RATING: PreparedStatement pst = myConn.prepareStatement("INSERT INTO RATING (ratingDate) VALUES(?)");…
I'm working on a simple account report with cumulative sum . I got the sql working in phpmyadmin . set @csum := 0; update accountssetup set BAL = (@csum := @csum + DR) WHERE Accounttype = 'EXPENSES' AND date ='2019-07-19'…
Basically I need to add a new column to a table. I need to call that column category and in that column of Category I want the default value to be the name of that new category column I will…
I have a pretty "basic" app that we designed that was originally on a local plesk server and we migrated to GAE/GSQL/GCS. app engine, mysql, cloud storage. Here's some background info: App is PHP based, and runs great on the…
Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SET `utf8` COLLATE `utf8_general_ci` NOT NULL DEFAULT `due`; I am getting this error: Missing comma before start of a new alter operation. (near "CHARACTER…
I have a Registration Form, but there are a few problems. This is my first registration form. Where the data is needed for data collection needs. But when someone registers, a lot of duplicate data is in PHPMyAdmin. I've tried…