I'm trying to learn PHP, and to do so I'm attempting to create a URL shortener. Right now you can currently input a link and it enters it into the database. It doesn't randomize the string, but I'm going to do that after. (I changed them myself to avoid running into problems).
Here is my table currently(My table is called 'urls'):
Then when you go to (for me localhost) /somepath it automatically redirects to /process.php?id=somepath
In process.php it checks if the specified path (somepath) exists in the database, then gets its original value. The problem I'm having is getting the original value. Again, I am new to PHP, and I'm having trouble understanding how querying works.
$query = "SELECT original FROM urls WHERE new = '$new'";
$result = $conn->query($query);
How do I grab information from $result? Or am I supposed to get it from $query after $result because that just basically runs it?
Please explain why you use what, I'm not understanding this.
Thanks, sorry if this is a really stupid question.