Advertisement
Guest User

example

a guest
May 16th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.16 KB | None | 0 0
  1. html>
  2. <head>
  3.     <title>HTML-форма добавления</title>
  4. </head>
  5. <body>
  6. <form aсtion="" method="post">
  7.     <table>
  8.         <tr><td>nomermap</td><td><input name="nomer_map" maxlength=5 size=5></td></tr>
  9.         <tr><td>coordX</td><td><input name="coord_x" maxlength=5 size=5></td></tr>
  10.         <tr><td>coordY</td><td><input name="coord_y" maxlength=5 size=5></td></tr>
  11.         <tr><td>coordZ</td><td><input name="coord_z" maxlength=5 size=5></td></tr>
  12.         <tr><td>typeground</td><td><input name="type_ground" maxlength=5 size=5></td></tr>
  13.         <tr><td>connect</td><td><input name="connect" maxlength=5 size=5></td></tr>
  14.         <tr><td>object</td><td><input name="object" maxlength=5 size=5></td></tr>
  15.         <tr><td>event</td><td><input name="event" maxlength=5 size=5></td></tr>
  16.         <tr><td colspan=2><input type="submit" value="Ввод"></td></tr>
  17.     </table>
  18. </form>
  19.  
  20. <?php
  21.  
  22. $nomer_map   = trim ( $_POST['nomermap'] );
  23. $coord_x = trim ( $_POST['coordx'] );
  24. $coord_y = trim ( $_POST['coordy'] );
  25. $coord_z = trim ( $_POST['coordz'] );
  26. $type_ground  = trim ( $_POST['typeground'] ) ;
  27. $connect = trim ( $_POST['connect'] );
  28. $object  = trim ( $_POST['object'] ) ;
  29. $event = trim ( $_POST['event'] );
  30.  
  31. $nomer_map   = addslashes ( $nomer_map );
  32. $coord_x = addslashes ( $coord_x );
  33. $coord_y = addslashes ( $coord_y );
  34. $coord_z = addslashes ( $coord_z );
  35. $type_ground  = addslashes ( $type_ground ) ;
  36. $connect = addslashes ( $connect );
  37. $object  = addslashes ( $object ) ;
  38. $event = addslashes ( $event );
  39.  
  40. $hostname = "localhost";
  41. $username = "root";
  42. $password = "22011978";
  43. $db = "globalmapv1";
  44.  
  45. $link = mysql_connect($hostname,$username,$password);
  46. if ( !$link ) die ("Íåâîçìîæíî ïîäêëþ÷åíèå ê MySQL");
  47. mysql_select_db ( $db ) or die ("Íåâîçìîæíî îòêðûòü $db");
  48.  
  49. $query = "INSERT INTO glmap1 VALUES ('"
  50.     .$nomer_map."', '".$coord_x."', '".$coord_y."', '"
  51.     .coord_z."', '".type_ground."', '".connect."', '".object."', '".event."')";
  52. $result = mysql_query ( $query );
  53. if ($result) echo "Ñòðîêà äîáàâëåíà â áàçó äàííûõ.";
  54. mysql_close ( $link );
  55. ?>
  56. </body>
  57. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement