Advertisement
jrp370

add entry

Feb 8th, 2012
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Perl 0.70 KB | None | 0 0
  1. sub addEntry {
  2.  
  3.    
  4.  
  5.            
  6.  
  7.     print"Please enter their name: \n";
  8.  
  9.     chomp (my $name = <STDIN>);
  10.  
  11.     $name = lc($name);
  12.  
  13.     if (exists $phonebook{$name}){
  14.  
  15.         print"$name is already in your phonebook\n";
  16.  
  17.     } else {
  18.  
  19.         print"Please enter their phone number (123 4567): \n";
  20.  
  21.         chomp (my $phone = <STDIN>);
  22.        
  23.  
  24.         $phonebook{$name} = $phone;
  25.  
  26.         my $sth; # statement handle
  27.  
  28.         $sth = $dbh->prepare('INSERT INTO Phonebook (name, Phone)
  29.  
  30.                      VALUES (?, ?)'
  31.  
  32.                     )
  33.  
  34.                 or die "Can't prepare SQL: " . $dbh->errstr();
  35.  
  36.         $sth->execute("$name", "$phone")
  37.  
  38.                 or die "Can't execute SQL: " . $sth->errstr();
  39.  
  40.             $sth->finish();
  41.  
  42.        
  43.  
  44.     }
  45.  
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement