edu Toidayhoc

Category: php Mysql

  • Khóa học miễn phí PHP & MySQL – Connect Database nhận dự án làm có lương

    PHP & MySQL – Connect Database Example

    PHP provides mysqli contruct or mysqli_connect() function to open a database connection. This function takes six parameters and returns a MySQL link identifier on success or FALSE on failure.

    Syntax

    $mysqli = new mysqli($host, $username, $passwd, $dbName, $port, $socket);

    Sr.No. Parameter & Description
    1

    $host

    Optional − The host name running the database server. If not specified, then the default value will be localhost:3306.
    2

    $username

    Optional − The username accessing the database. If not specified, then the default will be the name of the user that owns the server process.
    3

    $passwd

    Optional − The password of the user accessing the database. If not specified, then the default will be an empty password.
    4

    $dbName

    Optional − database name on which query is to be performed.
    5

    $port

    Optional − the port number to attempt to connect to the MySQL server..
    6

    $socket

    Optional − socket or named pipe that should be used.

    You can disconnect from the MySQL database anytime using another PHP function close().

    Syntax

    $mysqli->close();

    Example

    Try the following example to connect to a MySQL server −

    Copy and paste the following example as mysql_example.php −

    <html>
   <head>
      <title>Connecting MySQL Server</title>
   </head>
   <body>
      <?php
         $dbhost = ''localhost
         $dbuser = ''root
         $dbpass = ''root@123
         $mysqli = new mysqli($dbhost, $dbuser, $dbpass);

         if($mysqli->connect_errno ) {
            printf("Connect failed: %s<br />", $mysqli->connect_error);
            exit();
         }
         printf(''Connected successfully.<br />'');
         $mysqli->close();
      ?>
   </body>
</html>

    Output

    Access the mysql_example.php deployed on apache web server and verify the output.

    Connected successfully.

    Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc

  • Khóa học miễn phí PHP & MySQL – Create Database nhận dự án làm có lương

    PHP & MySQL – Create Database Example

    PHP uses mysqli query() or mysql_query() function to create or delete a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure.

    Syntax

    $mysqli->query($sql,$resultmode)

    Sr.No. Parameter & Description
    1

    $sql

    Required – SQL query to create a MySQL database.
    2

    $resultmode

    Optional – Either the constant MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT depending on the desired behavior. By default, MYSQLI_STORE_RESULT is used.

    Example

    Try the following example to create a database −

    Copy and paste the following example as mysql_example.php −

    <html>
   <head><title>Creating MySQL Database</title></head>
   <body>
      <?php
         $dbhost = ''localhost
         $dbuser = ''root
         $dbpass = ''root@123
         $mysqli = new mysqli($dbhost, $dbuser, $dbpass);

         if($mysqli->connect_errno ) {
            printf("Connect failed: %s<br />", $mysqli->connect_error);
            exit();
         }
         printf(''Connected successfully.<br />'');

         if ($mysqli->query("CREATE DATABASE TUTORIALS")) {
            printf("Database TUTORIALS created successfully.<br />");
         }
         if ($mysqli->errno) {
            printf("Could not create database: %s<br />", $mysqli->error);
         }
         $mysqli->close();
      ?>
   </body>
</html>

    Output

    Access the mysql_example.php deployed on apache web server and verify the output.

    Connected successfully.
Database TUTORIALS created successfully.

    Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc