Jump to content

how change this code from insert into just modify


Lisa23

Recommended Posts

how can i change this which insert into the database to display and modify i then resave back into the database

 

if(!empty($_POST['select1']) && $_POST['select1'] != 'default')
$value = mysql_real_escape_string($_POST['select1']);
elseif(!empty($_POST['select2']) && $_POST['select2'] != 'default')
$value = mysql_real_escape_string($_POST['select2']);
elseif(!empty($_POST['select3']) && $_POST['select3'] != 'default')
$value = mysql_real_escape_string($_POST['select3']);



    
    if ($_POST['name']=='')
        $arrErrors['name'] = 'Please provide your name.';
    if ($_POST['email']=='')
        $arrErrors['email'] = 'A valid email address is required.';
    if ($_POST['phone']=='')
        $arrErrors['phone'] = 'Please provide your phone number.';
        
        
        if ($_POST['campustype']=='')
        $arrErrors['campustype'] = 'Please select category.';
        
        
        
        
          if ($_POST['select1'] === 'default' && $_POST['select2'] === 'default' && $_POST['select3'] === 'default'){
                $arrErrors[howt] = 'Please select type';
        }else{
                $possible = array('Concerts', 'Clubs', 'Festival', 'Opera');
                if (in_array($_POST['select1'], $possible) === false){
                }
               
                $possible = array('Formula 1', 'Footbal', 'Basketball', 'Rugby', 'Cricket');
                if (in_array($_POST['select2'], $possible) === false){
                }
               
                $possible = array('Comedy', 'Drama', 'Museus');
                if (in_array($_POST['select3'], $possible) === false){
                        
             }
        
        }
    if (count($arrErrors) == 0)


$query="INSERT INTO photos values ('','$image','$name','$email','$phone','$campustype','$value')"; //into database
            mysql_query( $query ); 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.