I want to post this data from android client and i tested it with postman and status code was 200. But i have a mysqli error and it’s: Error: ((1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE id=’ at line 1)
Tag: php
Find which array an item is in given multiple arrays and item only exists in one in PHP/SQL
I have an ecommerce website and I have it set up that countries are split into different zones for shipping costs. I have 8 zones, these are all arrays of country codes, there can be no duplicates in …
all values not displaying from SQL data table in PHP
I am trying to display all my data from MySQL to PHP like the following, but only 1 data is being displayed
<…
Why is my php producing error when inserting data into SQL server?
I’m trying to get PHP to insert POST data from my html form into my SQL Server 2018 on a local machine. I looked at php documentation and follow it but i still don’t get it why the code is producing …
PHP – show category once per group
Categories, whilst only displaying the category title once. I have one table that holds the category title (the parent) and the second table which holds the sub-category information. Although when …
Fade in SQL results with jQuery
I have a php file that I have pulling in SQL elements from my database. My goal is that for each row of data that the div ‘moredetails’ would fade in on click (one at a time). However, the current …
How to display each row from sql in a table in php
I have a table within a modal. I want the table to display the top 3 goalscorers from a football game. The following code is not returning the table. Any help greatly appreciated!. At present I am …
Problem with deleting items from pivot table
I am building project for learning purposes in oop php where I create properties/ads, and I have three tables, properties, photos and property_photo. My goal is when I click on delete button to delete …
Uncaught PDOException: SQLSTATE[HY093] [closed]
I get this erro: Invalid parameter number: number of bound variables does not match number of tokens in C:xampphtdocsPHPtennisronde2-wijziging.php:59 // code van het knop wijzigen if(isset($…
How to access a table using a variable name in sql query
I have multiple tables in my database named teacher1, teacher2…. I am trying to access them using a variable $id. I have written down the following code. $query = “SELECT * FROM table.$id”; How …