}
if (func_num_args() > 1) {
$args = func_get_args();
$query = call_user_func_array("sprintf", $args);
}
try {
$this->QUERY = $query;
$this->RESULT = mysql_query($query);
if (!$this->RESULT) {
throw new Exception('Error: Query ($query) : ' . mysql_error() . print_r($this));
} else {
return $this->RESULT;
}
} catch (Exception $e) {
echo $e->GetMessage();
}
} else {
return "Error: No connection has been established to the database. Cannot stat query.";
}
}
/** Get Database name
* This method return the name of the current open db */
function CurrentDb()
{
$r = mysql_query("SELECT DATABASE()");
return mysql_result($r, 0);
}
}
// get instance of mysql db
$mysql = MySqlDb::getInstance();
ini_set('display_errors', '1');
include_once './db/dbconnect.php';
$school_name = $_GET['inpSchoolName'];
$school_type = $_GET['inpSchoolType'];
$school_addrlane1 = $_GET['inpaddrlane1'];
$school_addrlane2 = $_GET['inpaddrlane2'];
$school_city = $_GET['inpcity'];
$school_state = $_GET['inpstate'];
$school_phone = $_GET['inpphone'];
$school_email = $_GET['inpEmail'];
$school_overview = $_GET['inpoverview'];
$school_ann_fees = $_GET['inpAnualFee'];
$format = strtolower($_GET['format']) == 'json' ? 'json' : 'xml';
$result = '';
$link = NULL;
$db = MySqlDb::getInstance();
try {
$link = $db->connect('localhost', 'root', 'ramesha', 'mydb');
} catch (Exception $e) {
$result = $e->getMessage();
}
$query = "INSERT INTO school(school_name, school_addr, school_lat, school_lng, school_city, school_state, school_type, school_ann_fees, school_phone, school_email, school_overview, school_imgs_path, school_doa) VALUES ('{$school_name}','{$school_addrlane1} . {$school_addrlane2}', 10.000, 10.000, '{$school_city}', '{$school_state}', '{$school_type}', '{$school_ann_fees}', '{$school_phone}', '{$school_email}', '{$school_overview}', 'file', CURRENT_TIMESTAMP);";
$db->insert($query);
if ($format == 'json') {
header('Content-type: application/json');
echo json_encode('Everything is fine..');
} else {
header('Content-type: application/xml');
echo '<result>';
echo '<value>';
echo 'Data inserted successfully.';
