ben ben - 4 months ago 11
MySQL Question

Connecting my website to MySql database

The hosting site that I am using to host my website automatically links you phpmyadmin and MySql. What code do I need to connect to my specific database so that within my webpages I can edit the table?

ben ben
Answer

Answer:

            // Log into server
            $servername = "localhost";
            $username = "username";
            $password = "password";
            $dbname = "data base name";

            // Create connection
            $conn = mysqli_connect($servername, $username, $password, $dbname);
            // Check connection
            if (!$conn) {
                die("Connection failed: " . mysqli_connect_error());
            }           

            // truncate table
            $sql = "sql command here";
            $result = mysqli_query($conn, $sql);