I’m querying my DB twice to get some items into the header of the page and some bellow the header. I want to avoid duplicates in these two queries, currently I do this by adding a skip method to …
Tag: php
Script timeout passed error on MAMP phpmyadmin
I’m trying to upload this sql file that’s 225MB to phpmyadmin with MAMP. However, I keep getting this error Script timeout passed, if you want to finish import, please resubmit the same file and import will resume. I’ve changed the php.ini file in MAMP like so: I’ve also changed the se…
How to select only latest added records avoiding duplicates
I need to select from the table competition_rounds the latest added records which are linked to the competition_seasons table with the season_id column, eg: competition_rounds competition_seasons I want return only: the problem’s that my query return all rounds available: NB: The table competition simpl…
Is my site vulnerable to SQL injections if I get error 403?
I have a login form and just to test I tried to fill in “select * from accounts where username = test” and then I pressed enter to see what happens. I got redirected to this page: Should I be concerned about SQL injections? Or is this a normal response? Edit: the PHP code for this particular case.…
Uncaught mysqli_sql_exception: You have an error in your SQL syntax
I cant get my update button to work, my SQL syntax isnt targeting the datebase properly, this is the syntax im using $sql = (“UPDATE crud SET name=’$name’, last=’$last’, email=’$email’, birthday=’$…
How to follow user id to get sum of MySQL column in PHP?
I have a column in a table that I want to follow “user id = 3” to get sum of MySQL column in PHP. but it’s not working. Below is my code: <?php $sql_select_point = 'SELECT SUM(…
INNER JOIN is not working, i do not get errors
$result = mysqli_query($conn,”SELECT * FROM table1 INNER JOIN `table2` ON `table1`.`id`=`table2`.`id`;”); while ($row = mysqli_fetch_array($result) ){ echo ‘name ‘.$row[“name”].'<…
Why does my button not pass the Order ID onto another page?
I have a page called order_page.php and it has a hyperlink that should pass the Order ID of a particular order to another page called edit.php. I looked up some tutorials on youtube but it’s still …
ELOQUENT – Calculating difference of datetimes in where-clause
I am trying to check if the difference of two columns in my database is under a given amount of years – meaning DATETIME – BIRTHDATE where(date_diff((strtotime(‘…
Find all rows in between a set in PostgreSQL
I have a table named tc_fuel that is receiving all the fuel related data from GPS vehicles, and I want to get the last “Tank Usage” to calculate MPG for a whole tank, but the readings when the tank is …