I have an input field that I am trying to fill with an AJAX request to my SQL server using PHP, but it is not working. The console.log spits out the proper array title: "" description: "", but it doesnt…
I'm developing a simple web app with Node.js and Express. I have to query a database using mysql module. Every time I try to query the database it shows up this error: code: 'ER_BAD_DB_ERROR', errno: 1049, sqlMessage: "Unknown database 'moneydb'",…
I have online shop project, when someone click "purchase" -> he buy item. Now, i save the item (it's work) and want to update my Database (need to update the amount of those item's) from the cart. Controller - look…
I have this MySQL table MONTHNAME generated by querying from the database using the following script using PHP. $query = 'SELECT monthname(`dateAdded`) as MONTHNAME,sum(`shift1PinCount`+`shift2PinCount`) from `supervisorupdate` WHERE YEAR(`dateAdded`) = YEAR(CURDATE()) group by monthname(`dateAdded`) ORDER BY monthname(`dateAdded`) DESC'; $queryExecute = mysqli_query($conn,…
I have a database which store old installation wordpress tables. I would like to clean up a bit so I am looking for a query can delete the table based on the prefix table name. In this case I want…
I am currently working on a website have ran into an issue. I am trying to insert data from my database into a list. Currently I run a problem where either I get the error: Undefined variable: results in C:xampphtdocsportfolioindex.php…
A PHP Error was encountered Severity: Warning Message: mysqli::real_connect(): (HY000/2002): Connection timed out Filename: mysqli/mysqli_driver.php Line Number: 203 Backtrace: File: /var/www/html/medical-survey/application/models/Userdata_model.php Line: 8 Function: database File: /var/www/html/medical-survey/application/controllers/Admins.php Line: 9 Function: model File: /var/www/html/medical-survey/index.php Line: 315 Function: require_once and A Database…
Hi I'm relatively new to php and I'm making a booking system database and website using php,and phpmyadmin as a server. I need help with coding of the database. Specifically I'm trying to get the id of a logged in…
I have a column enabled with datatype bit(1). I am trying to save 0 or 1 value in Database by Laravel eloquent. $model->enabled = $inputs['enabled']; $model->save(); I have saved values in my config file. 'enabled' => [ '0' => 'No',…
I have a database named db_x on server X (running WHM) and another database named db_y on server Y. I connected to server X via SSH made some changes to the phpmyadmin configurations to allow it to connect to db_y…