Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 1 y…
Tag: php
Is this code protected for SQL injection?
is this safe enough? Or should it be improved? Is this code protected for SQL injection? (PHP) Answer I take it for granted that $wpdb is from the WordPress project. Then as explained by the documentation, the very purpose of these placeholders is to prevent SQL injections. Hence you can consider your code sa…
Can I use DECLARE as an SQL statement in PHP
I am trying to execute a query in PHP, but this code wouldn’t work for some reason, it doesn’t detect the keywords at all(DECLARE, SELECT, WHERE). Is there anything I can do and after all can I even use DECLARE in PHP as a mySQLi statement. $sql2 =”DECLARE @MaxID INT; SELECT @MaxID = MAX(pro…
PHP update record button not passing information to another page
im trying to make a update record button on php that when clicked, it’ll take you to another page showing only the information of the patient which update button was pressed. Im using the following to show the patient information along with an update button for each patient patients.php When I click the…
Loading table values into a poplist, current value displaying correctly
I have two tables in my library database, Books and BookTypes: When I load the Edit screen from my search results page, I have got the three types displaying. But can’t get the currently selected value of the book to display(It’s always Digital). My Edit Page Code is: How do I ensure the current v…
Database (1064) SQLSTATE[42000]: Syntax error | Importing using phpmydirectory
So, we use a script called “phpmydirectory”, and at this point it’s pretty outdated. It wasn’t designed to work on PHP 7+ or MySQL 5.7+ but we’re mostly making it work. Part of the script, …
How can you assign a value to a variable if mysql does not yield any result?
There are two databases. I am trying to see if email in the first database is also present in the second database. Here’s the code that I’ve tried: The output is: The type for onera and julian is blank because there email is not present in the phpbb_users database. How can I avoid this blank space…
Display each sql db row in a single php page
I’m trying to display each single row from my db as a separated unique page, so when I click on the row link (which I don’t even know what it is until now) it directs me to a new page with the content of this row or some of the content as I desire.. So I created a new php
Issue with uploading image using this.form.submit();
I am using this.form.submit(); in order to upload an image straight after it is sellected and also pass some other info along. I am having an issue, the submit works and passes the id with post but the image is not uploaded and the name is not inserted in the db it might add a name like 0_ but that
Inserting data into a table using foreign keys in MySQL
I am trying to insert data into a contacts table using foreign keys in mysql, the structure of tables are as follows The fk_id in the contacts table is the FOREIGN KEY and it relates to the pers_id PRIMARY KEY in the users table, I am trying to insert a new contact with relates to a user in the users