echo "<table border='1'>";
echo "<tr>";
echo "<th>personID</th>";
echo "<th>FirstName</th>";
echo "<th>LastName</th>";
echo "<th>Age</th>";
echo "</tr>";
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("SpiderResult.mdb");
$conn=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
$query=odbc_do($conn,"select top 10 * from content");
while(odbc_fetch_row($query)) {
echo "<tr>";
$personID = odbc_result($query,1);
$FirstName = odbc_result($query,2);
$LastName = odbc_result($query,3);
$Age = odbc_result($query,4);
echo "<td>" . $personID . "</td>";
echo "<td>" . $FirstName . "</td>";
echo "<td>" . $LastName . "</td>";
echo "<td>" . $Age . "</td>";
echo "</tr>";
}
echo "</table>";
odbc_close($conn);
//本站原创www.111cn.net
是获取表单的数据再用update更新到mysql教程数据库教程
if( $_POST )
{
$cid = PostGet('cid',1);
$address = PostGet('address',1);
$sql = "Update cn_loupan_city set address='$address' where id='$cid'";
$Db = new Db();
if( $Db->query( $sql ))
{
MessAge('修改成功');
}
else
{
MessAge('操作失败，稍后再试!');
}
unset( $Db );
}
<table width="64%" border="0" cellpadding="0" cellspacing="0">
<form name="form1" method="post" action="s.php教程">
<tr>
<td><input type="hidden" name="cid" value="<?=$id?>">
<textarea name="address" cols="60" rows="10" id="address"><?=iconv('GB2312', 'UTF-8', $row['address']); ?></textarea></td>
</tr>
<tr>
<td height="31"><input type="submit" name="Submit" value="保存修改"></td>
</tr>
</form>
</table>
//要想让php与pdo 就必须在php.ini里面修改一个参数把extension=php_pdo.dll ";"去了。
//
$path ="d:pdoddSpiderResult.db3";
$conn = new PDO("sqlite:$path");
$array=array('','','');
if( $conn )
{
echo ('pdo 连接正常connection pdo success');
}
else
{
echo ('pdo php cnnection pdo fail ,plase check database server!');
}
foreach ($conn->query('SELECT * FROM content limit 0,1') as $row)
{
print_r($row);
die();
}
//本站原创www.111cn.net
<HTML>
<HEAD>
<TITLE>php 适合入门者php 简单文件上传</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></HEAD>
<BODY>
<?
$UploadedFile=$_FILES['UploadedFile']['tmp_name'];
$UploadedFile_name=$_FILES['UploadedFile']['name'];
$isTrue=false;
if($UploadedFile)
{
$store_dir=$_SERVER['DOCUMENT_ROOT'];
$accept_overwrite = 1;
$isTrue=true;
}
$fileName = date("YmtHis").$UploadedFile_name;
if (file_exists($store_dir . $fileName))
{
echo "存在相同文件名的文件";
}
$mytype =array(".jpg",".gif",".png");
$filetype=substr($_FILES['UploadedFile']['name'],strrpos($_FILES['UploadedFile']['name'],"."));
$typecount=0;
if($isTrue)
{
for($i=0;$i<count($mytype);$i++)
{
if($filetype==$mytype[$i])
{
$typecount++;
}
}
if($typecount>0)
{
if($_FILES['UploadedFile']['size']<1048576)
{
$b=move_uploaded_file($UploadedFile,$store_dir.$fileName);
if($b)
{
echo "<HR> ";
echo "原文件信息：<br/>";
echo "名称:".$_FILES['UploadedFile']['name']."<BR> ";
echo "大小:".$_FILES['UploadedFile']['size']."<BR> ";
echo "类型:".$_FILES['UploadedFile']['type']."<BR> ";
echo "<HR> ";
echo "存入数据库教程的名称为：".$fileName;
echo "<HR> ";
}
}
else
{
echo "文件大小不准超过1兆.";
}
}
else
{
echo "不准上传次类型文件！";
}
}
?>
<FORM ENCTYPE="multipart/form-data" ACTION="<?php echo $PHP_SELF ?>" METHOD="post">
<INPUT NAME="UploadedFile" TYPE="file" size='15'>
<INPUT TYPE="submit" VALUE="上传文件">
</FORM>
</BODY>
</HTML>
$servername ='localhost';
$dbname='8684'; //数据库教程名
$dbusername ='root'; //数据库用户名
$dbpassword ='123456'; //数据库密码
$link=mysql教程_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname) or die();
mysql_query("set names 'gbk'");
function get_real_ip(){
$ip=false;
if(!empty($_SERVER["HTTP_CLIENT_IP"])){
$ip=$_SERVER["HTTP_CLIENT_IP"];
}
if(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ips教程=explode(",",$_SERVER['HTTP_X_FORWARDED_FOR']);
if ($ip){
array_unshift($ips,$ip);
$ip=FALSE;
}
for($i=0;$i<count($ips);$i++){
if (!eregi("^(10│172.16│192.168).",$ips[$i])){
$ip=$ips[$i];
break;
}
}
}
$ip=$ip?$ip:$_SERVER['REMOTE_ADDR'];
list($ip1,$ip2,$ip3,$ip4)=explode(".",$ip);
return $ip1*pow(256,3)+$ip2*pow(256,2)+$ip3*256+$ip4;
}
$ip=get_real_ip();
$sql="select * from ip where start<=$ip order by start desc limit 1";
$q=mysql_query($sql);
$rs=mysql_fetch_array($q);
$city=$rs["city"];
echo $city;