<?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>
Comments