1710069214

Connecting your application to the database in php


we can use these two functions to create our tables and handle our queries. **functions.php** ```php $host = 'localhost'; $data = 'platystation'; // here is the name of the database $user = 'root'; // db username $pass = 'root'; // db pass $chrs = 'utf8mb4'; $attr = "mysql:host=$host;dbname=$data;charset=$chrs"; $opts = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ]; try{ $pdo = new PDO($attr, $user, $pass, $opts); } catch(\PDOException $e){ throw new \PDOException($e->getMessage(), (int)$e->getCode()); } function createTable($name, $query){ queryMysql("CREATE TABLE IF NOT EXISTS $name($query)"); echo "Table '$name' created or already exists.<br>"; } function queryMysql($query){ global $pdo; return $pdo->query($query); } ``` create the table for the susarios. ```php createTable('users', 'user VARCHAR(20), email VARCHAR(100), pass VARCHAR(12), INDEX(user(20))'); ``` query to return data from the database ```php queryMysql("SELECT * FROM daname"); ``` query to insert data into the db ```php queryMysql("INSERT INTO dbname VALUES('$username','$password')"); ``` From there we can explain more options or queries such as delete, update, merge and so on.

To comment this publication you need to be logged in.
JavaJuggler
JavaJuggler
0

nice comment! good to have people who contribute in this way to the better learning of the guys here on the site.


Abid876
Abid876
0

`Connection:` Parameters for database connection details are set, including host, database name, username, password, and character set. These are used to establish a PDO connection. `Options`: PDO options are configured for error handling, fetch mode, and prepared statements emulation. `Table Creation`: The script contains a function to create tables with provided table name and schema. Tables are created if they don't exist. `Query Execution`: Another function executes queries directly using the PDO instance. This includes selecting and inserting data. **To enhance the script**: `Security`: Use prepared statements to prevent SQL injection. Error Handling: Provide better error messages for troubleshooting. Naming: Ensure clear and consistent naming for functions and variables. Documentation: Add comments to explain the purpose of each part of the script. Implementing these improvements will make the script more concise and robust. Thanks.