urlshorteners Database Table

Table: urlshorteners

Tool: URL Shortener
Associated Objects: URLShortener, URLShorteners, URLShortenerStats

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(50) NOT NULL v5

url VARCHAR(255) NOT NULL v5

member INT UNSIGNED NOT NULL DEFAULT 0 v5

extension VARCHAR(50) NOT NULL v5.06

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM urlshorteners");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $url = $resRow["url"];  //
 $member = $resRow["member"];  //
 $extension = $resRow["extension"];  //
}

Other URL Shortener Tables

urlshorteners urlshortenerstats

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us