Jump to content

Rate my code.


Recommended Posts

Posted
 protected function generateCode($num) {
    return base_convert($num, 10, 36);
  }
  public function createCode($url) {
    $url = trim($url);
    if(!filter_var($url, FILTER_VALIDATE_URL)) {
      return '';
    }
    $sth = $this->dbh->prepare('SELECT code FROM links WHERE url = :url');
    $sth->bindParam(":url", $url);
    $sth->execute();
    if(!$sth->rowCount() == 0) {
      return $sth->fetchColumn();
    } else {
      $sth = $this->dbh->prepare('INSERT INTO links (url, created) values (:url, NOW())');
      $sth->bindParam(":url", $url);
      $sth->execute();
      //Generate code
      $code = $this->generateCode($this->dbh->lastInsertId());
      $sth = $this->dbh->prepare('UPDATE links SET code = :code WHERE url = :url');
      $sth->bindParam(":code", $code);
      $sth->bindParam(":url", $url);
      $sth->execute();
      return $code;
    }
  }
  public function getCode($code) {
    $sth = $this->dbh->prepare('SELECT url FROM links WHERE code = :code');
    $sth->bindParam(":code", $code);
    $sth->execute();
    if(!$sth->rowCount() == 0) {
      return $sth->fetchColumn();
    }
    return '';
  }

Feel free to use this. It's for URL shortening. 

Posted
public function forceAutism($makesense) {
 $sth = $this->dbhandler->prepare('SELECT * FROM facial WHERE question = :makesense);
 $sth->bindParam(":makesense", $makesense);
 $sth->execute
 if($sth->rowCount() == 1) {
	return $autism;
 }
 return $autism;
}

this is meme

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...