Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last year. Improve this question I was having trouble while installing xampp in my pc. And then i found …
Tag: mysql
Update multiple row with insert new data in laravel
I am new to Laravel, here my existing fields are getting updated but unable to insert a new row, when users checks for a new category it should be added as a new row in the database. public function …
How to segregate data from each other with same value
I’ve got 2 tables in my database the first table is leader id | name | age 1 | John | 40 2 | Doe | 35 member id | name | age 1 | Mark | 40 2 | Jessica| 35 2 | Tiff | …
Returning a name from a column using the MAX() function on a different column
I had a quick question on how to return a certain value from a column after using the MAX() function on a different column. For instance, I am trying to return the full name of the comedian depending …
Trying to compare values from database and php file
I’m having trouble trying to compare my entries in a database with a php file, I have a connection and I’m getting results but I can tell I’m grabbing the whole list of entries and trying to compare …
mysql optimisation number of ads in a category
I have a personal ads website . First problem: I have 2 tables, category and ads. Category table (id is the primary key) | id | type | subtype | pos | +—–+————-+———–+-…
PHP & PDO: Fastest way to fetch data from
I have an HTML table which is fetched with thousands of rows of messages and the date these were sent by an user and I’m currently trying to understand how to fetch the data faster, as it takes 5 to 9 …
How to append data obtained from database to array?
I would like to append data(“username”) from database to array(“array1”) and write all items from array. I have marked problematic part of code. If I run this code, I see: What can be wrong? Output …
How to store and retrieve images of type data:image/jpeg;base64?
I’m trying to upload images from the front-end to my PHP server. I’m converting the image into data:image/jpeg;base64 using FileReader() in javascript. Here’s my js code: fileSelectHandler = (event) =…
MySQL. Retrieve data from many tables with column in common
I have the following tables in my database. TABLE_AVATAR TABLE_DOCUMENTS My goal is to retrieve all data from all the tables for each employee. TABLE_EMPLOYEES will contain 1 row per record (I need all data), TABLE_AVATAR can hold many rows per record (I only need the newest one (id desc)), and TABLE_DOCUMENT…