photos Database Table

Table: photos

Tool: Photos

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(100) v5

description VARCHAR(255) v5

added INT UNSIGNED v5

approved BIT(1) DEFAULT 0 v5

photocategory INT UNSIGNED v5

facebook VARCHAR(100) v5

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 photos");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $added = $resRow["added"];  //
 $approved = $resRow["approved"];  //
 $photocategory = $resRow["photocategory"];  //
 $facebook = $resRow["facebook"];  //
}

Other Photos Tables

photocategories photos

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us