sql

PHP + SQL

2023.05.02

Today, I learned that how to work PHP with SQL. This is the algorithms: Connect to the database. Handle connection errors. Execute the SQL query. Process the results. Free resources and close connection. PDO: PHP data Objects $connectionString = "mysql:host=localhost; dbname=bookcrm"; $user = "testuser"; $pass = "mypassword"; $pdo = new PDO($connectionString, $user, $pass); Normal MySQL: $host =..

Web Programming 🌏/Database 👩🏻‍🌾

Basic SQL

2023.04.28

Today, I learned SQL. SQL: A table is the principal unit of storage in database. It is a two-dimensional container for data that consists of records (rows); each record has the same number of columns. These columns are called fields, which contain the actual data. Each table will have a primary key -- a field (or sometimes combination of fields) that is used to uniquely identify each record in a..

PHP + SQL

Basic SQL

티스토리툴바