锐客网

  1. 首页 > 睿知 > it技术 > >

php修改数据库代码 phpstudy修改数据库密码

IT技术代码

php代码问题 如何修改数据库数据？共2个页面xianshi.php和edit.php$sql="update wp_prli_links set url='php修改数据库代码？' where id = $id ";这样不行就换种方式嘛php修改数据库代码 ， $url="?";
$sql="update wp_prli_links set url='".$url."' where id = $id ";
PHP修改数据库2修改页面php修改数据库代码：
?php
$host = "服务器";
$user = "用户名";
$pass = "密码";
$db = "数据库名";
$conn=mysql_connect($host,$user,$pass);
mysql_select_db($db,$conn);
mysql_query("SET NAMES 'gbk'");
?
?php
$mid=$_GET['mid'];
【php修改数据库代码 phpstudy修改数据库密码】$sql="select * from symbols where id='$mid'";
$query=mysql_query($sql);
$rs=mysql_fetch_array($query);
?
form method="post" action=""
tr
tdinput name='id1' type='text'value='https://www.04ip.com/post/?php echo $mid;?' disabled//td
tdinput name='country' type='text' id='country' value='https://www.04ip.com/post/?php echo $rs[1];?' //td
tdinput name='animal' type='text' id='animal' value='https://www.04ip.com/post/?php echo $rs[2];?' //td
tdinput name='cname' type='text'value="https://www.04ip.com/post/?php echo $rs['cname'];?" //td
tdinput name='bthModify' type='submit' id='bthModify' value='https://www.04ip.com/post/修改' //td
/tr
/form
?php
if($_POST['bthModify']){
$country=$_POST['country'];
$animal=$_POST['animal'];
$cname=$_POST['cname'];
$sql="update symbols set country='$country',animal='$animal',cname='$cname' where id='$mid'";
mysql_query($sql);
echo "scriptlocation.href='https://www.04ip.com/post/temp.php';/script";
}
显示页面php修改数据库代码：
?php
$host = "服务器";
$user = "用户名";
$pass = "密码";
$db = "数据库名";
$conn=mysql_connect($host,$user,$pass);
mysql_select_db($db,$conn);
mysql_query("SET NAMES 'gbk'");
?
table cellpadding=10 border=1
?php
$sql="select * from symbols";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
$id=$row[0];
?
form method="post" action=""
tr
td城市：?php echo $row[1];?/td
td镇：?php echo $row[2];?/td
td名字：?php echo $row[3];?/td
tda href="https://www.04ip.com/post/temp1.php?mid=?php echo $id;?"修改/a/td
/tr
/form
?php
}
?
/table
几种常用PHP连接数据库的代码示例PHP连接数据库之PHP连接MYSQL数据库代码
?php$mysql_server_name= localhost ;//改成自己php修改数据库代码的mysql数据库服务器$mysql_username= root ;//改成自己php修改数据库代码的mysql数据库用户名$mysql_password= ;//改成自己的mysql数据库密码$mysql_database= mycounter ;//改成自己的mysql数据库名$conn=mysql_connect($mysql_server_name $mysql_username $mysql_password $mysql_database);$sql= CREATE DATABASE mycounterDEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;;mysql_query($sql);$sql= CREATE TABLE `counter`(`id` INT( ) UNSIGNED NOT NULLAUTO_INCREMENT`count` INT( )UNSIGNED NOT NULL DEFAULTPRIMARY KEY( `id` ) ) TYPE = innodb; ;mysql_select_db($mysql_database $conn);$result=mysql_query($sql);//echo $sql;mysql_close($conn);echo "Hello!数据库mycounter已经成功建立php修改数据库代码！";?
PHP连接数据库之PHP连接ACCESS数据库代码方法
?$conn = new ("ADODB Connection");$connstr = "DRIVER={Microsoft Access Driver (* mdb)}; DBQ="realpath("data/db mdb");$conn Open($connstr);$rs = new ("ADODB RecordSet");$rs Open("select * from szd_t" $conn );while(! $rs eof) {$f = $rs Fields( );echo $f value;$rs MoveNext();}?
PHP连接数据库之PHP连接MS SQL数据库代码方法
安装SQL服务器并添加PHP的MSSQL扩展
使用以下代码连接并测试
?php$myServer = localhost; //主机$myUser = sa; //用户名$myPass = password; //密码$myDB = Northwind; //MSSQL库名$s = @mssql_connect($myServer$myUser$myPass)or die(Couldnt connect to SQL Server on $myServer);$d = @mssql_select_db($myDB$s)or die(Couldnt open database $myDB);$query = SELECT TitleOfCourtesy+ +FirstName+ +LastName AS Employee ;$query= FROM Employees ;$query= WHERECountry=USA AND Left(HomePhone) = ( );$result = mssql_query($query);$numRows = mssql_num_rows($result);echoh$numRowsRow($numRows ==? : s)Returned / h ;while($row = mssql_fetch_array($result)){echoli$row[Employee]/li;}?

推荐阅读


上一篇：直播常见问题话术模板，直播常见问题话术模板图片

下一篇：mysql存储过程行数据，mysql存储过程写法总结