PHP DATABASE::delete Examples

Programming Language: PHP

Class/Type: DATABASE

Method/Function: delete

Examples at hotexamples.com: 1

PHP provides several database drivers such as MySQL, PostgreSQL, SQLite, and many more. With PHP, you can perform various operations on a database, including inserting, updating, and deleting data from a database.

To delete data from a database in PHP, you can use the SQL DELETE statement. Here are some examples of how to delete data from a MySQL database using PHP.

Example 1: Delete a single record from the database

// Connect to the MySQL database
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');

// Delete a record
$id = 1;
$sql = "DELETE FROM users WHERE id = $id";
mysqli_query($conn, $sql);

// Close the database connection
mysqli_close($conn);

In this example, we first connect to the MySQL database using mysqli_connect(), passing in the hostname, username, password, and database name. We then execute an SQL DELETE statement using mysqli_query(), passing in the connection and the SQL statement. Finally, we close the database connection using mysqli_close().

Example 2: Delete multiple records from the database

// Connect to the MySQL database
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');

// Delete multiple records
$ids = [1, 2, 3];
$sql = "DELETE FROM users WHERE id IN (" . implode(',', $ids) . ")";
mysqli_query($conn, $sql);

// Close the database connection
mysqli_close($conn);

In this example, we use the IN operator to delete multiple records at once. We first connect to the MySQL database and then build the SQL statement dynamically using the implode() function to merge the IDs of the records to delete. We then execute the statement using mysqli_query() and close the database connection. Package/Library: Database operations in PHP can be done using built-in functions or with database abstraction libraries like Doctrine ORM, Laravel's Eloquent ORM, or Symfony's Doctrine DBAL.

PHP DATABASE::delete - 1 examples found. These are the top rated real world PHP examples of DATABASE::delete extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

getInstance(7)

select(5)

f(5)

insert(4)

DB(3)

connect(3)

init(3)

startswith(1)

records(1)

record(1)

query(1)

lastquerytime(1)

lastquery(1)

instance(1)

CONNECTION(1)

CreateDatabase(1)

delete(1)

close(1)

Query(1)

PDO(1)

INSTANCE(1)

INIT(1)

FETCHMODE(1)

update(1)

Example #1

Show file

File: asset.ajax.php Project: Omnomios/deepfield

					$data['y'] = $_POST['y'];
					$data['w'] = $_POST['w'];
					$data['h'] = $_POST['h'];
					$data['mip'] = $_POST['m'];
					if(DATABASE::update("sprite_frame",array("sprite_frame_id"=>$_REQUEST['sprite_frame_id']),$data)) echo "Frame updated successfully.";

				break;

				case "deleteitem":

					$frame = DATABASE::record("sprite_frame","sprite_frame_id",$_GET['id']);

					if(isset($_GET['confirm']) && $_GET['confirm'] == "true")
					{
						$data['sprite_frame_id'] = $_GET['id'];
						if(DATABASE::delete("sprite_frame",$data)) echo "Sprite frame deleted successfully.<br>";
						die();
					}
					?>
						<div>
						Delete frame "<?=$frame['name']?>"?
						</div>
						<div class="formbuttons">
							<button type="button" onClick="deleteframe(true)">Delete</button>
							<button type="button" onClick="clearform()">Cancel</button>
						</div>
					<?


				break;