Advertisement
Guest User

Untitled

a guest
Oct 6th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.61 KB | None | 0 0
  1. // Das wäre seite 1 - Mit dem Formular
  2. <form action="eintragen.php" method="post">
  3. <table border="0" cellspacing="2" cellpadding="2">
  4.   <tbody>
  5.     <tr>
  6.       <td align="right">Status:</td>
  7.       <td>
  8.         <select name="state">
  9.           <option value="0">Ausschalten</option>
  10.           <option value="1">Einschalten</option>
  11.         </select>
  12.       </td>
  13.     </tr>
  14.     <tr>
  15.       <td align="right">Sprache:</td>
  16.       <td>
  17.         <select name="language">
  18.           <option value="de">Deutsch</option>
  19.           <option value="nl">Niederländisch</option>
  20.           <option value="en">Englisch</option>
  21.           <option value="es">Spanisch</option>
  22.         </select>
  23.       </td>
  24.     </tr>
  25.     <tr>
  26.       <td align="right">Text:</td>
  27.       <td>
  28.         <input maxlength="500" name="text" size="45" type="text" />
  29.       </td>
  30.     </tr>
  31.     <tr>
  32.       <td></td>
  33.       <td>
  34.         <input type="submit" value="Abschicken" />
  35.       </td>
  36.     </tr>
  37.   </tbody>
  38. </table>
  39. </form>
  40.  
  41. // Das wäre seite 2 als php (eintragen.php) das script was den datensatz ändern soll
  42. <!DOCTYPE html>
  43. <html>
  44. <head>
  45.   <title>Eintrag wird verarbeitet</title>
  46. </head>
  47. <body>
  48. <?php
  49. $form = array
  50. $form['state'] = ['state'];
  51. $form['language'] = ['language'];
  52. $form['text'] = ['text'];
  53.  
  54.  
  55. $pdo = new PDO('mysql:host=localhost;dbname=db', 'user', '***');
  56.  
  57. $statement = $pdo->prepare("UPDATE ticker SET text = ? WHERE id = ?");
  58. $statement->execute(array("['text']", "['language']"));
  59.  
  60. $statement = $pdo->prepare("UPDATE ticker SET state = ? WHERE id = ?" ) ;
  61. $statement->execute($neuer_user);
  62. ?>
  63. </body>
  64. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement