连接到数据库失败

Question

我将一个数据库导入到我的PHPmyadmin中，该数据库在其中运行良好，但当我尝试使用

我的php文件，我不是真的，我唯一看到的是字段的行在顶部。

hier是我的应用；

<?php

  DEFINE('db_name', 'root');
  DEFINE('db_pass', 'root');
  DEFINE('db_host', 'localhost');
  DEFINE('db_database','SCV_DB');

  $dbcon =mysqli_connect("localhost", "root", "root", "SCV_DB");

  if (mysqli_connect_error()) {
    die('Connect Error ('.mysqli_connect_errno().') '.mysqli_connect_error());
  }
  $color=' well come to mysql';
  echo 'Connected successfully<br>';
  echo 'M. Mori ' . $color.'<br>';
  mysqli_set_charset($dbcon,"utf8");

  echo "<table><tr><th>SECTION</th><th>NAME</th><th>DATE</th><th>COUNTRY</th><th>PREIS</th></tr>";
  $consult="SELECT * FROM TABLE 1"; 

  $result=mysqli_query($dbcon,$consult);

  while($row = mysqli_fetch_row($result)) {
    echo "<tr><td>";
    echo $row[0]."</td><td>";
    echo $row[1]."</td><td>";
    echo $row[2]."</td><td>";
    echo $row[3]."</td><td>";
    echo $row[4]."</td></tr>";
  }

  echo "</table>";

?>

Answer 1

我讨厌mysqli的过程化风格，你应该使用面向对象的风格，更有用的是完整的here you can find more。

不管怎么说！我在玩程序连接，看到你的问题，希望它不是一个重复的问题:)

所以这是我玩的连接文件！您可以使用自己的连接。

$host = '127.0.0.1';
$db   = 'SCV_DB';
$user = 'root';
$pass = '';
$port = '3308'; //Or 3307
$charset = 'utf8mb4';

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);  
$dbcon  = mysqli_connect($host, $user, $pass, $db, $port, $charset);


if ($dbcon ->connect_error) {
    die("Connection failed: " . $dbcon ->connect_error);
}

下面是使用prepare语句的查询(当更新和插入数据时，prepare语句可以避免sql注入)

$sql = 'SELECT * FROM YourTableName';
$stmt = mysqli_prepare($dbcon ,$sql);
if(mysqli_stmt_execute($stmt)){
$getResult = mysqli_stmt_get_result($stmt);
    while($rows = mysqli_fetch_assoc($getResult)){
        echo "id: ".$rows['id'];
        echo "<br>";
        echo "First name: ".$rows['first_name'];
        echo "<br>";
        echo "Last name: ".$rows['last_name'];
        echo "<br>";
    }
}
mysqli_stmt_close($stmt);

Answer 2

<?php

  DEFINE('db_name', 'root');
  DEFINE('db_pass', 'root');
  DEFINE('db_host', 'localhost');
  DEFINE('db_database','SCV_DB');

  $dbcon =mysqli_connect("localhost", "root", "root", "SCV_DB");

  // Check connection
  if (!$dbcon) {
    die("Connection failed: " . mysqli_connect_error());
  }
  echo "Connected successfully";

  $color=' well come to mysql';
  echo 'Connected successfully<br>';
  echo 'M. Mori ' . $color.'<br>';
  mysqli_set_charset($dbcon,"utf8");
?>
    <table>
        <tr>
            <th>SECTION</th>
            <th>NAME</th>
            <th>DATE</th>
            <th>COUNTRY</th>
            <th>PREIS</th>
        </tr>
<?php
    $consult="SELECT * FROM TABLE 1";//Please Don't these name for table name  
    $result=mysqli_query($dbcon,$consult);
    while($row=mysqli_fetch_row($result)):?>

    <tr>
        <td><?php echo $row[0];?></td>";
        <td><?php echo $row[1];?></td>";
        <td><?php echo $row[2];?></td>";
        <td><?php echo $row[3];?></td>";
        <td><?php echo $row[4];?></td>";
    </tr>
    <?php endwhile;?>
    </table>

?>

Answer 3

Hier是数据库；

​

我希望这能帮助解决这个问题。