Advertisement
RieqyNS13

Untitled

Oct 22nd, 2012
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.39 KB | None | 0 0
  1. <?php
  2. if(!($link = @mysql_connect('127.0.0.1', 'root', ''))){
  3. $result = "Gagal nyambung ke server";
  4. }
  5. if(!(@mysql_select_db('test', $link))){
  6. $result = "Gagal nyambung database";
  7. }
  8. if(isset($_POST['btnSubmit'])){
  9. if(empty($_POST['txData'])){
  10. $data = trim($_POST['txData']);
  11. $result = "Data belum diisi";
  12. }else{
  13. $result = null;
  14. $data = trim(htmlentities($_POST['txData']));
  15. $exp = explode("\n", $data);
  16. for($i=0; $i<count($exp); $i++){
  17. $preg = mysql_real_escape_string(stripslashes(preg_replace("#\n|\r|\r\n#", '', $exp[$i])));
  18. $sql = mysql_query("SELECT content FROM test WHERE name='$preg';");
  19. if(@mysql_num_rows($sql)>=1){
  20. while($row = mysql_fetch_array($sql)){
  21. $result.= $preg." : ".$row['content']."\n";}
  22. }
  23. }
  24. }
  25. }else{
  26. $data = null;
  27. @$result = $result;
  28. }
  29. ?>
  30. <html>
  31. <head>
  32. <meta http-equiv="Content-type" content="text/html;charset=UTF-8">
  33. <style type="text/css">
  34. legend{
  35. text-align:center;
  36. border:solid #888 2px;
  37. }
  38. fieldset{
  39. width:335px;
  40. }
  41. </style>
  42. </head>
  43. <body>
  44. <center>
  45. <form action="<?php $_SERVER['PHP_SELF']; ?>" method=POST>
  46. <fieldset>
  47. <legend>Data</legend>
  48. <textarea cols="40" rows="10" name="txData"><?php echo $data; ?></textarea>
  49. </fieldset>
  50. <br>
  51. <input type="submit" name="btnSubmit"><br><br>
  52. <fieldset>
  53. <legend>Result</legend>
  54. <textarea cols="40" rows="10" name="txResult"><?php echo $result; ?></textarea>
  55. </fieldset>
  56. </form>
  57. </center>
  58. </body>
  59. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement