- public function get_insert_db_sql($tbl_name,$info)
- {
- if(is_array($info)&&!empty($info))
- {
- $i = 0;
- foreach($info as $key=>$val)
- {
- $fields[$i] = $key;
- $values[$i] = $val;
- $i++;
- }
- $s_fields = "(".implode(",",$fields).")";
- $s_values = "(\'".implode("\',\'",$values)."\')";
- $sql = "INSERT INTO
- $tbl_name
- $s_fields
- VALUES
- $s_values";
- Return $sql;
- }
- else
- {
- Return false;
- }
- }
-
-
- public function get_replace_db_sql($tbl_name,$info)
- {
- if(is_array($info)&&!empty($info))
- {
- $i = 0;
- foreach($info as $key=>$val)
- {
- $fields[$i] = $key;
- $values[$i] = $val;
- $i++;
- }
- $s_fields = "(".implode(",",$fields).")";
- $s_values = "(\'".implode("\',\'",$values)."\')";
- $sql = "REPLACE INTO
- $tbl_name
- $s_fields
- VALUES
- $s_values";
- Return $sql;
- }
- else
- {
- Return false;
- }
- }
-
-
- public function get_update_db_sql($tbl_name,$info,$condition)
- {
- $i = 0;
- $data = \'\';
- if(is_array($info)&&!empty($info))
- {
- foreach( $info as $key=>$val )
- {
- if(isset($val))
- {
- $val = $val;
- if($i==0&&$val!==null)
- {
- $data = $key."=\'".$val."\'";
- }
- else
- {
- $data .= ",".$key." = \'".$val."\'";
- }
- $i++;
- }
- }
- $sql = "UPDATE ".$tbl_name." SET ".$data." WHERE ".$condition;
- return $sql;
- }
- else
- {
- Return false;
- }
- }
|