PHP - Help Finding Code Sorry

I have build a small form that take the zip code that user enter and if is on my list will redirect to a sub domain craigslist.   I was checking all the zip codes and is pretty hard to know to what bigger city to attribute the  given zip code and for that I was thinking to a simple idea to use, I am not sure how much exact will be but I think will do the trick for the moment.   The zip code range start from  00501 to 99950.    I create a array with the biggest city shown in craigslist and the zip code that correspond.    Now the tricky part, what I will do with the rest of the zip codes and my idea is to measure the distance from one to another zip code and which zip code from the array is closer from given one  to take it.

<?php 

$zip = $_GET['zip']; 


    $z = array (
36830 => array ( 'auburn.craigslist.org' ),
35242 => array ( 'bham.craigslist.org' ),
36301 => array ( 'dothan.craigslist.org' ),
35630 => array ( 'shoals.craigslist.org' ),
35901 => array ( 'gadsden.craigslist.org' )


?>




Exemple:

$zip= 36870 // the code received from the user

36870 - $array=  ( 'auburn.craigslist.org' ),
           (36830  = 40)
           (36301 = 569)
           (36911 = -41)  // the minus will be excluded
           (....etc)

After checking the zip code with  the ones from array, the smaller score will attribute the sub-domain  correspond from the array. I hope will don  t be the case when will get  the same result from two zip codes:)     Now I am using this rule:

$zip0 = (isset($z[$zip][0]) && $z[$zip][0] != '') ? $z[$zip][0] : 'craigslist.org/about/sites#US';

and I was thinking to redirect the user for a page to enter the state and the city. But I wish to make it more precises and not to involved the user so much.     But if there are any other suggestions I will be glad to hear them.

I am trying to insert into my database and it's just not having non of it. No errors are comming up at all, but no data is getting passed through.

Code: [Select]
if(isset($_POST['sub'])) {

include("../scrips/php/cms/database.insert.class.php");
$table = "blog_posts";
$title = $_POST['ArticleTitle'];
$img = "2";
$post = $_POST['ArticleBody'];
$aurthor_id = "1";
$category_id = "4";
$date_posted = "NOW()";
$values = array("$title","$img","$post","$aurthor_id","$category_id","$date_posted");
$fields = array('title','img','post','aurthor_id','category_id','date_posted');
//echo $values['0']."<br/>".$fields['0'];
//$obj->ArticleInsert($table,$fields,$tvalues);

$values_imploded = implode("','",$values);
$fields_imploded = implode(",",$fields);
$i = "INSERT INTO $table ($values_imploded) VALUES ($fields_imploded)";
mysql_query($i) or die( "<br>Query string: <br>Produced error: " . mysql_error() );;

}

Okay I'm done with searching for answers, working on this preg_match for about 3 hours now.   I'm looking for "($0.01/$0.02 USD)" in a string. The needle might be slighty different. Possible strings that I might look for is:

(€xx.xx/€xx.xx EUR) where the EUR can be changed into USD, including its signs.

Hi

I have a file, that is copied from other files. All other files work perfectly.
But, for some reason this one is throwing back an error.

I've been over it so many time, but can't see whats wrong.

Error:
Fatal error: Call to undefined method stdClass::save() in /home/p/o/powtest/web/public_html/admin/lib/ajax_php/add_interests.php on line 28


add_interests.php
Code: [Select]
<?PHP
require_once("../../../includes/initialize.php");

$flag = 0;
$ID = $_POST['ID'];
$type = $_POST['type'];
$category = $_POST['category'];
$interest = $_POST['interest'];
$expInt = explode("\n", $interest);
$DMOD = date('Y-m-d');
$TMOD = date('H:i:s');

$check_entry = Admin_interest::if_exists(clean_input_value($category));
if($check_entry == 0){
$new_category = Admin_interest::make($ID, clean_input_value($category), clean_input_value($type), $DMOD, $TMOD);
if($new_category && $new_category->save()){
$CID = $new_category->id;
$flag = 1;
}
}


foreach($expInt as $expInts){

$check_entry = Admin_interests_sub::if_exists($CID, clean_input_value($expInts));
if($check_entry == 0){
$new_interest = Admin_interests_sub::make($ID, $CID, clean_input_value($expInts), $DMOD, $TMOD);
if($new_interest && $new_interest->save()){
$message = 'Thank You: Your list Has Been Saved';
}else{
$message = "Sorry, There was an error";
}
}

}

echo $message;
?>


Class:
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Admin_interests_sub {

protected static $table_name="admin_interests_sub";
protected static $db_fields = array('id', 'category_id', 'interest_sub', 'dateMod', 'timeMod');
public $id;
public $category_id;
public $interest_sub;
public $dateMod;
public $timeMod;


public static function make($ID, $category_id, $interest_sub, $DMOD, $TMOD){
if(!empty($interest_sub)){
$interest = new Admin_interests_sub();
$interest->id = (int)$ID;
$interest->category_id = (int)$category_id;
$interest->interest_sub = $interest_sub;
$kw->dateMod = $DMOD;
$kw->timeMod = $TMOD;
return $kw;
}else{
return false;
}
}

protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

}

?>


Any help finding this bug will be a big help.

Thanks

I am trying to find the URL to a directory TWO levels above the script level (if you know what I mean).

For example.. the script sits at
Code: [Select]
http://www.domain.com/TestArea2/members/index.php
BUT I need to find the path to 
Code: [Select]
http://www.domain.com/TestArea2/

the nearest I get is...


$domain = $_SERVER['HTTP_HOST'];
$domain .=  $_SERVER['REQUEST_URI'];
echo $domain; // outputs www.domain.com/TestArea2/members/index.php 



Is there a simple method to do this or have I got to split the string and work backwards?

Many thanks