<HTML> <BODY> <?php //mysql_connect("127.0.0.1:3306", "root", "madmax1.") or die(mysql_error()); //mysql_select_db("mydb") or die(mysql_error()); include "../common/functions.php"; db_utility::db_connect(); function getmaxprimarykey($tablename) { $select = 'select primary_key from ' . $tablename . ' order by primary_key DESC'; $results = mysql_query($select) or die("Failed Query of " . $select); $firstrow = mysql_fetch_array($results); return $firstrow['primary_key']; } function check_dataset_exists($dataset) { $select = 'select count(data_set) from job_info where data_set=\'' . $dataset . '\''; $results = mysql_query($select) or die("Failed Query of " . $select); $firstrow = mysql_fetch_array($results); if ($firstrow['count(data_set)'] > 0) { die("Data_set name already exists. Terminating."); } } function insertarrayintodb($array, $tablename) { $fields = ""; $values = ""; for ($i = 0; $i < sizeof($array); ++$i) { $val = $array[$i]['value']; if (!is_null($val) && !empty($val)) { if (!empty($fields)) {
static function pageCounter() { $uri = $_SERVER['REQUEST_URI']; if (strpos($uri, '?') != false) { $uri = substr($uri, 0, strpos($uri, '?')); } db_utility::db_connect(); $query1 = "select hits from page_counters where uri='" . $uri . "'"; $result1 = mysql_query($query1) or die("Failed Query of " . $query1); $row1 = mysql_fetch_array($result1); if ($row1 == null) { $query2 = "insert into page_counters (uri,hits) values ('" . $uri . "',1)"; } else { $query2 = "update page_counters set hits=" . ($row1['hits'] + 1) . " where uri='" . $uri . "'"; } mysql_query($query2) or die("Failed Query of " . $query2); }