-
Database connection using mysqli in php
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "myproject_db"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }You have to provide your server, username, password, and database name to connect the database.
Code Snippet Queries: sql
- How to check the MySQL version
- Get create table Query from existing table in phpMyAdmin
- How to create a new table from existing table in SQL
- Change existing MySQL table column id to autoincrement
- Drop foreign id column (user_id) in MySQL
- Insert multiple rows in a single MySQL query
- Get data in random order with limit from table using mysql
- 1553 Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint
- SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1
- How to check column exists or not in table using MySQL
- SQL query to delete records older than 6 months
- Create column after a column in existing table using query in MySQL
- Cannot drop index 'fk_role_id': needed in a foreign key constraint
- How to retrieve data from two tables with one SQL statement