Forum Moderators: coopster
Code in PHP for my requirement:
<?
/**
* This function execute a query then return the query result!
* Return SQL result
*/
function runquery($query){
return mysql_query($query);
}
/**
* This function check the input from user is valid?
* Return TRUE if valid, FALSE otherwise
*/
function dataCheck(){
if (!isset($_POST['Field1'])) return FALSE;
if (!isset($_POST['Field2'])) return FALSE;
if (!isset($_POST['Field3'])) return FALSE;
return TRUE;
}/**
* This function call dataCheck(), if the input is valid, it call runquery() (many times)for save data to database
*/
function dataSave(){
if (!dataCheck()) return;
if (!runquery("INSERT INTO table1 SET FF=".$_POST['Field1'])) return;
if (!runquery("INSERT INTO table2 SET FF=".$_POST['Field2'])) return;
runquery("INSERT INTO table3 SET FF=".$_POST['Field3']);
}
/**
* Save data to database
*/
dataSave();
?>
Simulation code in C++ or Java:
sqlresult runquery(query q) throws DataException{
sqlresult r = mysql_query(q);
if (r == false)
throw new DataException('Query error');
return r;
}
int dataCheck() throws DataException{
if (!post[1])
throw new DataException('Field 1 is empty');
if (!post[2])
throw new DataException('Field 2 is empty');
if (!post[3])
throw new DataException('Field 3 is empty');
return 1;
}
void dataSave() throws DataException{
dataCheck();
//Operation '.' for string concatenate is only symbolic
runquery("INSERT INTO table1 SET FF=".post[1]);
runquery("INSERT INTO table1 SET FF=".post[2]);
runquery("INSERT INTO table1 SET FF=".post[3]);
}
try{
dataSave();
}catch(DataException e){
e->printBackTrace();
}
You can see that function dataSave() use many other functions with a simpler code