PHPの基本に関する質問

PHPの基本的な質問

PHPコード

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
<?php
    $conn = mysql_connect('localhost', 'root', '');
    if(!$conn)
    {
        echo "数据库连接失败".mysql_error();
        exit();
    }
    echo "数据库连接成功</br>";
    $sql = "show databases";  //查找某个库是否存在
    print("$sql</br>");
    $sql_return = mysql_query($sql);
    echo "$sql_return </br>";
    while($row = mysql_fetch_array($sql_return))
    {
        for($i = 0; $i != count($row); ++$i)
        {
            printf("%s", $row[0]);
            echo "</br>";
        }
    }
    //mysql_select_db('web', $conn);
    
?>

ログイン後にコピー

PHPコード

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
数据库连接成功
show databases
Resource id #4 
information_schema
information_schema
mysql
mysql
performance_schema
performance_schema
test
test
web
web

ログイン後にコピー

mysql_fetch_array() は数値配列と連想配列の両方を返します。代わりに mysql_fetch_row() を使用できます

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->数据库连接成功
show databases
Resource id #4 
Array ( [0] => information_schema [Database] => information_schema ) Array ( [0] => mysql [Database] => mysql ) Array ( [0] => performance_schema [Database] => performance_schema ) Array ( [0] => test [Database] => test ) Array ( [0] => web [Database] => web )

ログイン後にコピー