user3537990
user3537990

Reputation:

Code from database not returning

So I'm working on a URL shortener and in my database I have an id,url,code, and created. So basically my code goes through and checks if the url entered exists then returns the code, but for some reason the code isn't being returned. Here's what I got.

My Shorten.php class

  <?php
class Shortener{
protected $db;

public function __construct(){
    $this->db = new mysqli('localhost','root','wayne123','s');
}
protected function generateCode($num){
    # code...
}
public function makeCode($url)
{
    $url = trim($url);

    if(!filter_var($url, FILTER_VALIDATE_URL)){
        return '';
    }

    $url = $this->db->escape_string($url);

    //Check if exists
    $exists = $this->db->query("SELECT code FROM links WHERE url = '{$url}'");

    if($exists->num_rows){
        return $exists->fetch_objects()->code;
    }
    else{

    }

}
public function getUrl($code){
    # code...
}

}

And my shorten.php

  <?php
  session_start();
  require_once 'classes/Shortener.php';

  $s = new Shortener;

  if (isset($_POST['url'])){
$url = $_POST['url'];

if($code = $s->makeCode($url)){
    echo $code;

}else{
    //Problem
}

 }

Upvotes: 0

Views: 46

Answers (1)

user3052629
user3052629

Reputation:

you forgot the () at the $s = new Shortener();

Upvotes: 2

Related Questions