I want to have result of my query as it was before I replaced db connection using PDO. How can I get the query as i t was before I implemented PDO? This is my query: $query = “SELECT `…
Tag: mysql
How to save multiple inputs in laravel in mysql database?
I have a ticketing system in laravel and my problem is I have multiple input fields in my site which are title fname lasname and that came from the inputs of how many passengers are included. Now I have two tables which are booking and booking_details. I want to save the Contact Details and Mobile Number (whi…
Images are upload in folder via form but name in DB is not image name. Instead it’s a path to XAMPP tmp file?
In my admin table, the column image is showing this path after the image uploads: C:xampptmpphpC6DA.tmp but image name don’t. Image is perfectly uploaded to desired folder and that is ok… I’…
Trying to connect two tables together by using id value from one table on the other
So i’m pretty new to sql and i’m trying to figure out how to connect two tables together. I have a table named customers and a table named pets and i want to assign the pets to specific customers. …
(“SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)”)
I tried deploying my project to an AWS EC2 server but when I tried to run php artisan migrate I am getting the following error. PDOException::(“SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)”) PDO::__construct(“mysql:host=127.0.0…
Mysql – how to do this sql
I have a “reviews” table with N records with 3 fields. Field ID, field name and score field. What I am trying to do is a query that returns me a grouping by the “score” field but with values …
MYSQL prepared statment query not matching WRITTERID with WRITTER
I am trying to query a mysql statement to give match the writterid and writter in a drop down. How should i set this up because everything looks correct? I have already made the non-prepared …
how to turn Aggregates with multiple table into USE DB at laravel?
How can I write the query like that on Laravel, btw I’m using DB I followed this instruction https://dba.stackexchange.com/questions/175786/join-multiple-tables-for-aggregates, but still not get it …
How to calculate if the difference from current date and another date is equal or minus of a number of days
I use this query to calculate if the current date minus another date is minus or equal an amount of days. Unfortunately this query only works if the calculation of days is inside the same month. Let’s …
Converting Epoch timestamp to DateTime
Hello i am experiencing a strange problem, my scenario is that i am reading the history of google chrome browser stored in sqlite database using c# language. every thing goes fine except the timestamp …