simple_url_shortener.php

<?php
    $link = mysqli_connect("localhost", "newuser", "password", "proj1");
    
    if($link === false){
        die("ERROR: Could not connect. " . mysqli_connect_error());
    }
    
    // Attempt select query execution
    $q = $_GET['q'];
    $sql = "SELECT * FROM t2 WHERE f1 = '$q'";  
    if($result = mysqli_query($link, $sql)){
        if(mysqli_num_rows($result) > 0){
          $row = mysqli_fetch_array($result);
          $loc = $row['f2'];
        }
    }
    mysqli_close($link);
    header('Location: '.$loc);
?>