|
<?php $connect = mysql_connect("localhost","user","password"); if($connect) echo "Connect Successed!"; //连接成功,显示Connect Successed! else echo "Connect Failed!"; //连接失败,显示Connect Failed! ?> |
<?php $connect = @mysql_connect("localhost","user","password") or die ("Unable to connect database server!"); ?> |
<?php $connect = @mysql_connect("hostname","user","password") or die("Unable to connect database server!"); $close = @mysql_close($connect) or die ("Unable to close database server connect!"); ?> |
<?php $select = mysql_select_db(\'forum\' , $connect); if($select) {echo "connect db forum successed!";} else {echo "connect db forum failed!";} ?> |
<?php $select = mysql_select_db("forum",$connect) or die("Can not connect this DB!"); ?> |
<?php $connect = mysql_connect($hostname,$user,$pwd); $select = mysql_select_db($dbname,$connect); $query = mysql_query($sql , $connect); if($query) echo "Successed !"; else echo "Failed !"; ?> |
<?php $connect = mysql_connect($hostname , $user , $pwd); $query = mysql_db_query($dbname , $sql , $connect); if($query) echo "Successed !"; else echo "Failed !"; ?> |
<?php $query = mysql_query($sql , $connect); while($arrary = mysql_fetch_array($query)) { echo $array[column1]." │ ".$array[column2]; //echo $array[0]." │ ".$array[1]; } ?> |
<?php $query = mysql_query($sql , $connect); while($row = mysql_fetch_row($query)) { echo $row[0] . " │ " . $row[1] . "<br>"; } ?> |
<?php $query = mysql_query($sql , $connect); echo mysql_result($query , 0 , "column1")."<br>"; echo mysql_result($query , 1, "column1")."<br>"; echo mysql_result($query , 2, "column1")."<br>"; ?> |
<?php $query = mysql_query($sql , $connect); while($object = mysql_fetch_object($query)) { echo $object->column1 . "<br>"; echo $object->column2 . "<br>"; echo $object->column3 . "<br>"; } ?> |
<?php $query = mysql_query($sql , $connect); $seek = mysql_data_seek($query , 2); $arrary = mysql_fetch_array($query); echo $array[column1]."<br>"; echo $array[column2]."<br>"; ?> |
<?php $connect = mysql_connect("$hostname","$user","$pwd"); $create = mysql_create_db("dbtest" , $connect); if($create) echo "create database dbtest successed!"; else echo "create database dbtest failed!"; ?> |
<?php $connect = mysql_connect("$hostname","$user","$pwd"); $create = mysql_drop_db("dbtest" , $connect); if($create) echo "drop database dbtest successed!"; else echo "drop database dbtest failed!"; ?> |
<?php $query = mysql_query($sql , $connect); while($object = mysql_fetch_field($query)) { echo "table name : ".$object->table."<br>"; echo "field name : ".$object->name."<br>"; echo "primary key : ".$object->primary_key."<br>"; echo "not null : ".$object->not_null."<br>"; echo "field type : ".$object->type."<br>"; echo "field max length : ".$object->max_length."<br>"; } ?> |
<?php $query = mysql_query($sql , $connect); $object = mysql_fetch_field($query , 2); echo "table name : ".$object->table."<br>"; echo "field name : ".$object->name."<br>"; echo "primary key : ".$object->primary_key."<br>"; echo "not null : ".$object->not_null."<br>"; echo "field type : ".$object->type."<br>"; echo "field max length : ".$object->max_length."<br>"; ?> |
<?php $query = mysql_query($sql , $connect); $seek = mysql_field_seek($query , 2); $object = mysql_fetch_field($query); echo "table name : ".$object->table."<br>"; echo "field name : ".$object->name."<br>"; echo "primary key : ".$object->primary_key."<br>"; echo "not null : ".$object->not_null."<br>"; echo "field type : ".$object->type."<br>"; echo "field max length : ".$object->max_length."<br>"; ?> |
<?php $connect = mysql_connect($host , $usr ,$pwd); $dbs = mysql_list_dbs($connect); $rows = mysql_num_rows($dbs); echo "database total : ".$rows; $i = 0; while($i<$rows) { $db_name[$i] = mysql_tablename($dbs , $i); echo $db_name[$i]; $i++; } ?> |
<?php $connect = mysql_connect($host , $usr , $pwd); $tables = mysql_list_tables("mysql"); $rows = mysql_num_rows($tables); echo "Table total : ".$rows; $i = 0; while($i<$rows) { $table_name[$i] = mysql_tablename($tables , $i); echo $table_name[$i]; $i++; } ?> |
|Archiver|小黑屋|星韵百科|星韵地理网 ( 苏ICP备16002021号 )
GMT+8, 2024-5-17 16:47 , Processed in 0.065066 second(s), 20 queries .
Powered by Discuz! X3.5
© 2001-2024 Discuz! Team.