Home
My Quiz

Table Under All Row Delete and Autoincrement Php Code

Publish: 06 March 2024, 4:44 pm IST | Views: Page View 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