search
HomeBackend DevelopmentPHP TutorialPHP MySQL creates database and table examples


  1. //Create database

  2. $con = mysql_connect("localhost","peter","abc123");

  3. if ( !$con)

  4. {

  5. die('Could not connect: ' . mysql_error());

  6. }

  • if (mysql_query("CREATE D ATABASE my_db", $con))

  • { bbs.it-home.org

  • echo "Database created";

  • }

  • else

  • {

  • e cho "Error creating database : " . mysql_error();

  • }

  • mysql_close($con);

  • ?>

  • 2, create table CREATE TABLE is used to create a database table in MySQL.

    Grammar CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, ....... ) In order to execute this command, I have to add a CREATE TABLE statement to the mysql_query() function.

    Example, create a table named "Persons" with three columns. The column names are "FirstName", "LastName" and "Age":




  1. $ con = mysql_connect("localhost ","peter","abc123");
  2. if (!$con)
  3. {
  4. die('Could not connect: ' . mysql_error());
  5. }
  6. D // Create database
  7. if (mysql_query ("Create DataBase My_db", $ Con) {bbs.it-home.org
  • echo "database created";
  • }
  • else
  • {
  • echo "Error creating database: " . mysql_error();
  • }
  • // Create table in my_db database
  • mysql_select_db ("my_db", $con);
  • $sql = "CREATE TABLE Persons
  • (
  • FirstName varchar(15),
  • LastName varchar(15),
  • Age int
  • )";
  • mysql_query($sql,$con);
  • mysql_close($con);
  • ?>
  • Copy code

  • Important: Before creating a table, you must first select the database. Select the database through the mysql_select_db() function.
  • Note: When you create a database field of varchar type, you must specify the maximum length of the field, for example: varchar(15).

    MySQL data types Various MySQL data types:
  • $sql = "CREATE TABLE Persons

  • (
    1. personID int NOT NULL AUTO_INCREMENT,
    2. PRIMARY KEY(personID) ,
    3. FirstName varchar(15),
    4. LastName varchar(15),
    5. Age int
    6. )";
    7. mysql_query($ sql,$con);
  • Statement
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Where are PHP session files stored by default?Where are PHP session files stored by default?May 01, 2025 am 12:15 AM

    PHPsessionfilesarestoredinthedirectoryspecifiedbysession.save_path,typically/tmponUnix-likesystemsorC:\Windows\TemponWindows.Tocustomizethis:1)Usesession_save_path()tosetacustomdirectory,ensuringit'swritable;2)Verifythecustomdirectoryexistsandiswrita

    How do you retrieve data from a PHP session?How do you retrieve data from a PHP session?May 01, 2025 am 12:11 AM

    ToretrievedatafromaPHPsession,startthesessionwithsession_start()andaccessvariablesinthe$_SESSIONarray.Forexample:1)Startthesession:session_start().2)Retrievedata:$username=$_SESSION['username'];echo"Welcome,".$username;.Sessionsareserver-si

    How can you use sessions to implement a shopping cart?How can you use sessions to implement a shopping cart?May 01, 2025 am 12:10 AM

    The steps to build an efficient shopping cart system using sessions include: 1) Understand the definition and function of the session. The session is a server-side storage mechanism used to maintain user status across requests; 2) Implement basic session management, such as adding products to the shopping cart; 3) Expand to advanced usage, supporting product quantity management and deletion; 4) Optimize performance and security, by persisting session data and using secure session identifiers.

    How do you create and use an interface in PHP?How do you create and use an interface in PHP?Apr 30, 2025 pm 03:40 PM

    The article explains how to create, implement, and use interfaces in PHP, focusing on their benefits for code organization and maintainability.

    What is the difference between crypt() and password_hash()?What is the difference between crypt() and password_hash()?Apr 30, 2025 pm 03:39 PM

    The article discusses the differences between crypt() and password_hash() in PHP for password hashing, focusing on their implementation, security, and suitability for modern web applications.

    How can you prevent Cross-Site Scripting (XSS) in PHP?How can you prevent Cross-Site Scripting (XSS) in PHP?Apr 30, 2025 pm 03:38 PM

    Article discusses preventing Cross-Site Scripting (XSS) in PHP through input validation, output encoding, and using tools like OWASP ESAPI and HTML Purifier.

    What is autoloading in PHP?What is autoloading in PHP?Apr 30, 2025 pm 03:37 PM

    Autoloading in PHP automatically loads class files when needed, improving performance by reducing memory use and enhancing code organization. Best practices include using PSR-4 and organizing code effectively.

    What are PHP streams?What are PHP streams?Apr 30, 2025 pm 03:36 PM

    PHP streams unify handling of resources like files, network sockets, and compression formats via a consistent API, abstracting complexity and enhancing code flexibility and efficiency.

    See all articles

    Hot AI Tools

    Undresser.AI Undress

    Undresser.AI Undress

    AI-powered app for creating realistic nude photos

    AI Clothes Remover

    AI Clothes Remover

    Online AI tool for removing clothes from photos.

    Undress AI Tool

    Undress AI Tool

    Undress images for free

    Clothoff.io

    Clothoff.io

    AI clothes remover

    Video Face Swap

    Video Face Swap

    Swap faces in any video effortlessly with our completely free AI face swap tool!

    Hot Tools

    EditPlus Chinese cracked version

    EditPlus Chinese cracked version

    Small size, syntax highlighting, does not support code prompt function

    PhpStorm Mac version

    PhpStorm Mac version

    The latest (2018.2.1) professional PHP integrated development tool

    SecLists

    SecLists

    SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

    Safe Exam Browser

    Safe Exam Browser

    Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

    Zend Studio 13.0.1

    Zend Studio 13.0.1

    Powerful PHP integrated development environment