PHP   

How to add new record in Database using PHP and mysqli

$conn = new mysqli("localhost","root","password","dbname");
if(! $conn ) {
   die('Could not connect to the database ');
}
$userName = "russel";
$userEmail = "[email protected]";
$timestamp = date('Y-m-d H:i:s');

$insertData = "INSERT INTO users (username, email, timestamp) VALUES ('$userName', '$userEmail', '$timestamp')";

if (mysqli_query($conn, $insertData)) {  
	echo "Record added successfully";
} 
else {
	echo "Error adding record: " . mysqli_error($conn);
}
Need Professional Support for Your Website Problems?

Whether you're facing website issues or struggling with code implementation, our team is here to assist. Hire us to get your website back on track.

Hire Us

Got an idea? We'll turn it into reality.

Tell us what you're building, what's broken, or what numbers need to move. We'll come back within one business day with a short plan — no long decks, no sales calls without purpose.

Response time: First reply within 1 business day on 100% of messages.
Transparent scope: Fixed proposals with weekly check-ins & live task tracking.
Ship-ready builds: Every engagement leaves behind documented, transferable work.
Long-term partners: Ongoing retainers for support, SEO, ads, and content.