Tech One more quick question, click counting - GoFuckYourself.com

Publisher Bucks · 08-08-2022, 08:58 PM

I'm *trying* to use the following code (link.php) to update a column in my db to count clicks to external links:

Quote:

<?php

/** Connect to DB */

mysqli_connect("localhost", "user", "pass", "db") or die(mysqli_error());

$link = $_GET['ID'];

/** Increase the counter of the URL to which the user is going*/

mysqli_query("UPDATE Directory SET Clicks = count + 1 WHERE ID = $link") or die(mysql_error());

/** Retrieves URL */

$result = mysqli_query("SELECT * FROM Directory WHERE ID = ID") or die(mysqli_error());

$row = mysqli_fetch_array($result);

//redirects them to the link they clicked
header( "Location:" .$row['Website'] );

?>

But its telling me that my query is incorrect, I thought I only had to update the count into the 'Clicks' column in the database?

The link.php page is just opening, with no redirect.

Do I need to do something else with the query or the database column to make this work?

LaSexorcisto · 08-08-2022, 10:58 PM

This is how PHP got labeled as a shitty unsecured language that's easy to hack. I've been defending the language for 15+ years saying its not the language that's bad.

Klen · 08-08-2022, 11:58 PM

Did you tested first query in database over tool like phpmyadmin ?

k0nr4d · 08-09-2022, 12:18 AM

Ignoring all the SQL injection etc,

UPDATE Directory SET Clicks = count + 1 WHERE ID = '$link'
should be
UPDATE Directory SET Clicks = Clicks + 1 WHERE ID = '$link'

08-09-2022, 12:18 AM	#4
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,229	Ignoring all the SQL injection etc, UPDATE Directory SET Clicks = count + 1 WHERE ID = '$link' should be UPDATE Directory SET Clicks = Clicks + 1 WHERE ID = '$link' __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development

08-08-2022, 10:58 PM	#2
LaSexorcisto Confirmed User Industry Role: Join Date: Mar 2022 Location: In the moment Posts: 95	This is how PHP got labeled as a shitty unsecured language that's easy to hack. I've been defending the language for 15+ years saying its not the language that's bad.

08-08-2022, 11:58 PM	#3
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	Did you tested first query in database over tool like phpmyadmin ?