cvs: php-hosts-web / host-add.php table.sql
| From: | jim winstead | Date: | Mon, 22 Apr 2002 18:36:17 +0000 |
| Subject: | cvs: php-hosts-web / host-add.php table.sql | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-9777@lists.php.net to get a copy of this message | ||
jimw Mon Apr 22 14:36:17 2002 EDT
Modified files:
/php-hosts-web host-add.php table.sql
Log:
start tracking when host records are created and updated
Index: php-hosts-web/host-add.php
diff -u php-hosts-web/host-add.php:1.6 php-hosts-web/host-add.php:1.7
--- php-hosts-web/host-add.php:1.6 Sun Apr 21 22:56:31 2002
+++ php-hosts-web/host-add.php Mon Apr 22 14:36:17 2002
@@ -46,8 +46,8 @@
echo "Use your browser's back button to correct these errors.";
} else {
- $query = "INSERT INTO $HOSTS_TABLE
(HostName,HostURL,HostInfoURL,HostEmail,HostPhone,HostFax,HostCity,HostState,HostCountry) ";
- $query.= "values
('$hostname2','$hosturl2','$hostinfourl2','$hostemail2','$hostphone2','$hostfax2','$hostcity2','$hoststate2','$hostcountry')";
+ $query = "INSERT INTO $HOSTS_TABLE
(HostName,HostURL,HostInfoURL,HostEmail,HostPhone,HostFax,HostCity,HostState,HostCountry,created,lastupate)
";
+ $query.= "values
('$hostname2','$hosturl2','$hostinfourl2','$hostemail2','$hostphone2','$hostfax2','$hostcity2','$hoststate2','$hostcountry',NOW(),NOW())";
$q1 = mysql_query($query) or die ("\"$query\" is a bad query.");
$hostid = mysql_insert_id();
Index: php-hosts-web/table.sql
diff -u php-hosts-web/table.sql:1.4 php-hosts-web/table.sql:1.5
--- php-hosts-web/table.sql:1.4 Sun Apr 21 20:02:42 2002
+++ php-hosts-web/table.sql Mon Apr 22 14:36:17 2002
@@ -42,6 +42,8 @@
HostCity varchar(32) default NULL,
HostState varchar(32) default NULL,
HostCountry char(2) default NULL,
+ created datetime NOT NULL,
+ lastupdate datetime NOT NULL,
PRIMARY KEY (HostID),
KEY HostName (HostName)
) TYPE=MyISAM;