Table Under All Row Delete and Autoincrement Php Code
Publish: 06 March 2024, 4:44 pm IST | Views: 138
<?php
// Include database connection
$dbHost = "localhost";
$dbUser = "";
$dbPass = "";
$dbName = "";
// Create a database connection
$conn = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
// Check the connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// SQL query to delete all rows from the table
$sqlDelete = "DELETE FROM users";
// Execute the query to delete rows
if (mysqli_query($conn, $sqlDelete)) {
echo "All rows deleted successfully from the users table.";
} else {
echo "Error deleting rows: " . mysqli_error($conn);
}
// Reset auto-increment to start from 1
$sqlResetAI = "ALTER TABLE users AUTO_INCREMENT = 1";
// Execute the query to reset auto-increment
if (mysqli_query($conn, $sqlResetAI)) {
echo "Auto-increment reset successfully.";
} else {
echo "Error resetting auto-increment: " . mysqli_error($conn);
}
// Close the database connection
mysqli_close($conn);
?>
कोड को Apply करने से Table के अंदर Column को छोड़कर, Column के अंदर के सभी Row डिलीट हो जाएगा, और नया एंट्री करने पर Number 1 से स्टार्ट होगा
Categories: Uncategorized








