Im trying to help someone to implement new function on his code; but I have this error Unfortunately if change the SQL_mode the request doesn’t work. ( really strange because this code works on the server ). If you have any idea. Even if with the documentation of SQL I can find the solution to modify th…
Tag: sql
How can I filter one column by two AND conditions?
The question has been resolved. But if you have a “better” or another way to do it then feel free to add a comment! Thanks all for reading! 🙂 I’m trying to make a dynamic query. Everything is …
how to show image from php to another
I want to show all images from database in interface the page index.php
&…
PHP- Insert all table values to DB in a single click and edit value?
how to insert all table values into the database with a single submit button? how to edit the tables values and update to the database? for the following code snippet in the code i want to insert …
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens – help needed
I’ve tried making a website which has a database connected to it and I’m getting the error message below INSERT INTO Diák (oktatási_id, vezeték_név, kereszt_név, évfolyam, születési_dátum, város,…
How to insert a value to a column where another column is equal to specific word?
I am currently working on an enrollment website for our research project. How to assign the section of a student where the course is “Computer Programming” limited to 50 per section? I currently have …
Table query, select data from table1, but only if user settings in table2 is set to a specific value
I got a problem with this query. Not sure what this type of problem is called, so have problems searching for a solution 🙁 I got two tables: configurations, users Lets say the tables looks like …
chose another column if the first column is null
how to chose another column if the first one is null i have users table who have email phone and other data i have registration form built with php what i want is check if user insert an email or …
Insert PHP into code web design without a large block of code. Solved [closed]
I am fairly new to PHP/SQL I have been lightly playing with it for a year or so and I decided to start getting into it more. First question I guess would be, is inserting into web design. Is there …
How to make a union query using Laravel Eloquent and Laravel Query Builder?
I am using laravel eloquent to CRUD data. My Problem is, I don’t know how to make UNION queries using laravel Eloquent ORM. Can you help me to solve my problem? This is my sample query that i want to …