Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(!($link = @mysql_connect('127.0.0.1', 'root', ''))){
- $result = "Gagal nyambung ke server";
- }
- if(!(@mysql_select_db('test', $link))){
- $result = "Gagal nyambung database";
- }
- if(isset($_POST['btnSubmit'])){
- if(empty($_POST['txData'])){
- $data = trim($_POST['txData']);
- $result = "Data belum diisi";
- }else{
- $result = null;
- $data = trim(htmlentities($_POST['txData']));
- $exp = explode("\n", $data);
- for($i=0; $i<count($exp); $i++){
- $preg = mysql_real_escape_string(stripslashes(preg_replace("#\n|\r|\r\n#", '', $exp[$i])));
- $sql = mysql_query("SELECT content FROM test WHERE name='$preg';");
- if(@mysql_num_rows($sql)>=1){
- while($row = mysql_fetch_array($sql)){
- $result.= $preg." : ".$row['content']."\n";}
- }
- }
- }
- }else{
- $data = null;
- @$result = $result;
- }
- ?>
- <html>
- <head>
- <meta http-equiv="Content-type" content="text/html;charset=UTF-8">
- <style type="text/css">
- legend{
- text-align:center;
- border:solid #888 2px;
- }
- fieldset{
- width:335px;
- }
- </style>
- </head>
- <body>
- <center>
- <form action="<?php $_SERVER['PHP_SELF']; ?>" method=POST>
- <fieldset>
- <legend>Data</legend>
- <textarea cols="40" rows="10" name="txData"><?php echo $data; ?></textarea>
- </fieldset>
- <br>
- <input type="submit" name="btnSubmit"><br><br>
- <fieldset>
- <legend>Result</legend>
- <textarea cols="40" rows="10" name="txResult"><?php echo $result; ?></textarea>
- </fieldset>
- </form>
- </center>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement