Размер файла: 1.78Kb
<?php
header("Content-type: text/vnd.wap.wml; charset=utf-8");
echo '<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="main" title=".:SQL =» MySQL:."><p align="left">';
if($mode!="do")
{
echo 'MySQL host:<br/>
<input name="host" value="localhost"/>
<br/>MySQL DataBase Name:<br/>
<input name="db"/><br/>
MySQL User Name:<br/>
<input name="user"/><br/>
MySQL Password:<br/>
<input name="password"/><br/>
SQL File address (full or local):<br/>
<input name="address" value="http://"/>
<br/><anchor>GO!
<go href="'.$_SERVER['PHP_SELF'].'?mode=do" method="post">
<postfield name="host" value="$(host)"/>
<postfield name="db" value="$(db)"/>
<postfield name="user" value="$(user)"/>
<postfield name="password" value="$(password)"/>
<postfield name="address" value="$(address)"/>
</go></anchor>';
}
if($mode=="do")
{
$data=@file_get_contents($address) or die("Could not read ".$address."! </p></card></wml>");
$queryes=preg_split("#(SELECT|CREATE|DROP|UPDATE|INSERT|SHOW|REVOKE|MATCH|LIKE|GRANT|DESCRIBE|OPTIMIZE|COUNT|ALTER|AGAINST|)[-a-z0-9_.:@&?=+,!/~*'%$\"\s\n]*;#i", $data);
$connect=mysql_connect($host, $user, $password) or die("Could not connect with MySQL server Because ".mysql_error()."</p></card></wml>");
@mysql_select_db($db) or die("Could not select the database because ".mysql_error()."</p></card></wml>");
$i=0;
$ie=0;
foreach($queryes as $query)
{
if(!@mysql_query($query))
{
echo '<strong>ERROR!</strong><br/>
<u>query:</u> '.$query.'<br/>
<u>server reply:</u> '.mysql_error().'<br/>------<br/>';
$ie++;
}
else $i++;
}
if($ie=="0")
echo 'Process finish!<br/>We have all '.$i. 'query and 0 errors!';
else echo 'We have '.($i+$ie).' query. '.$ie.' errors!';
@mysql_close();
}
echo '</p></card></wml>';
?>