Below is the code I used in order to upload files into a directory. It works fine. My main question is: move_uploaded_file() is the one that saves the uploaded file into the directory, and it is also my guess that move_uploaded_file() is the one that sets the name for it. How could I change the name of my fil…
Tag: mysql
Having trouble optimizing MySQL query with GROUP BY … HAVING
I’m trying to optimize quickly optimize the search functionality of some outdated forum software written in PHP. I’ve got my work down to a query that looks like this: word1 and word2 are examples; there could be any number of words. The number at the very end of the query is the total number of w…
Check for duplicate emails before querying
I’ve searched and look at other examples but as i’m new i’m having trouble translating over to my code. What I want to do is have it check the database to see if that email has already been entered. If it has I want it to tell them it has and that there is only one entry per person. Any
Unknown Column in Field List. PHP + Mysql
I’m trying to add values to a table in phpmyadmin and I get the error: Unknown column ‘…’ in ‘field list’. Here’s my code: so when I enter fds as name in the form on the previous page I get : Unknown column ‘fds’ in ‘field list’. This never hap…
SQL Export – WordPress plugin DEV
Hi So i have the following code.. Now, it works but doesnt download the file. Saying headers already sent. headers already sent by (output started at /Applications/XAMPP/xamppfiles/htdocs/~/wp-admin/includes/template.php:1642) Now i understand that the headers have been sent from my main plugin file already t…
Where does Facebook store multi millions of Images and Videos. In database or somewhere else? if so, Where? [closed]
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 10 months ago. Improve this question I am completely new to database. I require some information regardi…
SHOW COLUMNS from multiple tables
I am trying to get the column names from 2 tables. I tried a query like: (SHOW COLUMNS FROM users) UNION (SHOW COLUMNS FROM posts) but that does not work & returns a syntax error. I tried the same query using DESCRIBE but that did not work either. How can I get all the column names from multiple tables in
MySQL SSL Remote Connection Error: Unable to get Private Key
I am attempting to write a PHP script (hosted on a VPS with GoDaddy) that connects to a remote MySQL database (hosted on an Amazon EC2 instance) using SSL. I generated some certs (as per http://dev….
Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
How do I fix the error below? Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I use my NAS with a telnet connection. I installed FFP 0.7 My php.ini is in: ffp/etc/php.ini and I uncommented everything I thought to be of use. Below is a portion of my php.ini file;…
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”
Using a form, I was trying to insert data into my database. The initial SQL query had variables for values, but it didn’t work. After trying a few things and using mysqli_error I wasn’t able to find the problem. I then replaced all the variables with strings, still, my data does not insert. I̵…