Jump to content


Photo

editing data


  • Please log in to reply
1 reply to this topic

#1 Mr Chris

Mr Chris
  • Members
  • PipPipPip
  • Advanced Member
  • 336 posts

Posted 26 June 2006 - 11:56 AM

Hi Guys,

I have this script to edit data in the DB:

<?php 

//Connect to DB 
include("*************");

//Gets stories from the database
if(isset($_GET['story_id'])) 
{ 
    $result = mysql_query("Select * From cms_stories where story_id=".$_GET['story_id'],$link);
    $row = mysql_fetch_array($result);
    $section = $row['section']; 
    $added_by = $row['added_by']; 
    $headline = $row['headline']; 
    $byline_name = $row['byline_name']; 
    $appeared = $row['appeared']; 
    $published = $row['published']; 
    $opening = $row['opening']; 
    $body_text = $row['body_text']; 
    $picture = $row['picture']; 
    $pic_caption = $row['pic_caption']; 
    $pic_ref = $row['pic_ref']; 
    $notes = $row['notes']; 
} 

//Submit the edited data to the database
if(isset($_POST['Submit'])) 
{ 

    $section = $_POST['section'];
    $added_by = $_POST['added_by'];
    $headline = $_POST['headline'];
    $byline_name = $_POST['byline_name'];
    $appeared = $_POST['appeared'];
    $published = $_POST['published'];
    $opening = $_POST['opening'];
    $body_text = $_POST['body_text'];
    $pic_caption = $_POST['pic_caption'];
    $pic_ref = $_POST['pic_ref'];
    $notes = $_POST['notes']; 
        $result = mysql_query("cms_stories set section='$section', added_by='$added_by', headline='$headline', byline_name='$byline_name', appeared='$appeared', published='$published',opening='$opening', body_text='$body_text', pic_caption='$pic_caption', pic_ref='$pic_ref', notes='$notes' where story_id=$story_id"); 
        $msg = "Record is updated"; 
} 

?>

…But I want to add these conditions if submit is hit:

       if (empty($section)){
        $error = "** You forgot to enter the section for the story! **"; 
    }  else if (empty($added_by)){
        $error = "** Error: You forgot to who added the story! **";
    }  else if (empty($headline)){
        $error = "** Error: You forgot to enter a headline for the story! **";
    }  else if (empty($byline_name)){
        $error = "** Error: You forgot to enter a byline name for the story! **";
    }  else if (empty($published)){
        $error = "** Error: You forgot to the date you wish to publish the story! **";
    }  else if (empty($opening)){
        $error = "** Error: You forgot to the Opening Paragraph for the Indexes! **";
    }  else if (empty($body_text)){
        $error = "** Error: You forgot to enter any body text! *";

…But can't work out how do I do this? Can anyone advise?

Thanks

Chris

#2 Orio

Orio
  • Staff Alumni
  • Advanced Member
  • 2,491 posts

Posted 26 June 2006 - 12:55 PM

if(isset($_POST['Submit'])) 
{ 

    $section = $_POST['section'];
    $added_by = $_POST['added_by'];
    $headline = $_POST['headline'];
    $byline_name = $_POST['byline_name'];
    $appeared = $_POST['appeared'];
    $published = $_POST['published'];
    $opening = $_POST['opening'];
    $body_text = $_POST['body_text'];
    $pic_caption = $_POST['pic_caption'];
    $pic_ref = $_POST['pic_ref'];
    $notes = $_POST['notes'];

$error="";
       if (empty($section)){
        $error = "** You forgot to enter the section for the story! **<br>"; 
    }  else if (empty($added_by)){
        $error = "** Error: You forgot to who added the story! **<br>";
    }  else if (empty($headline)){
        $error = "** Error: You forgot to enter a headline for the story! **<br>";
    }  else if (empty($byline_name)){
        $error = "** Error: You forgot to enter a byline name for the story! **<br>";
    }  else if (empty($published)){
        $error = "** Error: You forgot to the date you wish to publish the story! **<br>";
    }  else if (empty($opening)){
        $error = "** Error: You forgot to the Opening Paragraph for the Indexes! **<br>";
    }  else if (empty($body_text)){
        $error = "** Error: You forgot to enter any body text! **<br>";};

if(strlen($error)>0){die($error);};

        $result = mysql_query("cms_stories set section='$section', added_by='$added_by', headline='$headline', byline_name='$byline_name', appeared='$appeared', published='$published',opening='$opening', body_text='$body_text', pic_caption='$pic_caption', pic_ref='$pic_ref', notes='$notes' where story_id=$story_id"); 
        $msg = "Record is updated";

If there's an error, stop and echo it, else continue to update [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]

Orio.
Think you're smarty?

(Gone until 20 to November)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users