000webhost/아이엠앱에서 php로 DB 접속

 

데이타베이스 접속//테이블 생성

<?php

           $con=mysqli_connect("localhost","USER_ID","USER_PWD","DB_NAME");

           // Check connection

           if (mysqli_connect_errno())

          {

                     echo "Failed to connect to MySQL: " . mysqli_connect_error();

          }

 

 

           // Create table

           $sql="CREATE TABLE users(ID INT user_name CHAR(30), firstname CHAR(30), lastname CHAR(30), email CHAR(30))";

 

           // Execute query

           if (mysqli_query($con,$sql))

          {

                     echo "Table persons created successfully";

          }

           else

          {

                     echo "Error creating table: " . mysqli_error($con);

          }

?>

 

데이타베이스 테이블에 항목추가

 

<?php

    $con=mysqli_connect("localhost","localhost","USER_ID","USER_PWD","DB_NAME");

    // Check connection

    if (mysqli_connect_errno())

    {

        echo "Failed to connect to MySQL: " . mysqli_connect_error();

    }

    echo $sql;

 

    $sql = "INSERT INTO DB_NAME.users (id, user_name, firstname, lastname, email)    

    VALUES ('7','hopman7', 'Dog man7','gold Smith7', 'john7@example.com')";

 

    echo $sql;

 

    // if ($mysql_query($sql) === TRUE) {

    //     echo "New record inserted successfully";

    // } else {

    //     echo "Error: " . $sql . "<br>" . $conn->error;

    // }

 

    if ($con->query($sql) === TRUE) {

        echo "Table MyGuests created successfully";

    } else {

        echo "Error creating table: " . $conn->error;

    }

 

    $conn->close();

?>

 

데이타베이스 테이블 내용 조회

 

<?php

   

  $con=mysqli_connect("localhost","localhost","USER_ID","USER_PWD","DB_NAME");

    // Check connection

    if (mysqli_connect_errno())

     {

     echo "Failed to connect to MySQL: " . mysqli_connect_error();

     }

     

    $query = "SELECT id, user_name FROM DB_NAME.users";

 

    $res = $con->query($query); 

    //$res = mysqli_query($conn, $query);

    

    $num =$res->num_rows ;

 

    if ($res->num_rows > 0)   {

        // output data of each row

        while($row = $res->fetch_assoc()) {

            echo "id: " . $row["id"]. " - Name: " . $row["user_name"]. "<br>";

        }

    } else {

        echo "0 results";

    }

    $con->close();

?>