Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id name dob gen
- 1 James 12-03-1977 M
- 2 James 12-03-1977 M
- 3 James 12-03-1977 M
- class Detail
- {
- function savePerson_detail($vars){
- foreach($vars as $key => $value){
- if(is_numeric($key) && $value >0){
- $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')",
- mysql_real_escape_string($vars['name']),
- mysql_real_escape_string($vars['dob']),
- mysql_real_escape_string($vars['gen']));
- mysql_query($qry) or die(mysql_error());
- if($qry)
- {
- print 'Successfully Insert your details';
- }
- }
- }
- <?php
- $detail = new Detail();
- if(isset($_POST['btnSaveDetail'])){
- $detail->savePerson_detail($_POST);
- }?>
- function savePerson_detail($vars)
- {
- // validate function input
- foreach($vars as $key => $value)
- {
- if(!is_numeric($key) || !$value >0)
- return;
- }
- // build sql query
- $qry = sprintf(
- "INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')",
- mysql_real_escape_string($vars['name']),
- mysql_real_escape_string($vars['dob']),
- mysql_real_escape_string($vars['gen'])
- );
- // run sql query
- $result = mysql_query($qry) or die(mysql_error());
- // check query result
- if($result)
- {
- print 'Successfully Insert your details';
- }
- }
- foreach($vars as $key => $value){
- $_POST['name'] = 'James';
- $_POST['dob'] = '12-03-1977';
- $_POST['gen'] = 'M';
- function savePerson_detail($vars){
- $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')", mysql_real_escape_string($vars['name']), mysql_real_escape_string($vars['dob']), mysql_real_escape_string($vars['gen']));
- mysql_query($qry) or die(mysql_error());
- if($qry)
- { print 'Successfully Insert your details'; }
- }
- class Detail
- {
- function savePerson_detail($vars) {
- foreach($vars as $key => $value) {
- $vars[$key] = mysql_real_escape_string($value);
- }
- if($qry)
- {
- print 'Successfully Insert your details';
- }
- $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')";
- mysql_query($qry) or die(mysql_error());
- }
Add Comment
Please, Sign In to add comment