如何从网址拨打电话号码

Question

I am making an affiliate program where I count a number of clicks based on this link fridgeblasteraffiliate.freeiz.com/affiliate/?numberherebasedonid but I have this

    <?php
$conn = mysqli_connect("redacted", "redacted", "redacted", 
"redacted");
 if (!$conn) {
     die("Connection failed: ".mysqli_connect_error());
 }
 session_start();
  $url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
 $sql = "SELECT clicks FROM affiliate WHERE ID='$ID'";
 $add = 1;
 $ID = strpos($url, needle)
 ?>

but as you can see I can't figure out how to call the number in the url to count the clicks

Answer 1

You want to use a GET variable. Try the following URL:

fridgeblasteraffiliate.freeiz.com/affiliate/?id=numberherebasedonid

Then use $_GET['id'] in your script to access the value.

$sql = "SELECT clicks FROM affiliate WHERE ID='$_GET['id']'";

Please note, though, that this code is vulnerable to SQL injection. As Magnus Eriksson noted in the comments, you can negate this by either typecasting $_GET['id'] to the int type, or by using prepared statements:

Casting:

$id = (int)$_GET['id'];
$sql = "SELECT clicks FROM affiliate WHERE ID='$id'";

Prepared statements:

$statement = $conn->prepare('SELECT clicks FROM affiliate WHERE ID=?');
$statement->bind_param('s', $_GET['id']);
$statement->execute();