PHP DATABASE::update Examples

Programming Language: PHP

Class/Type: DATABASE

Method/Function: update

Examples at hotexamples.com: 1

There are many PHP database update packages available for developers to use. These packages have different features and capabilities, so it is important to evaluate and determine which one meets your needs.

Here are some examples of PHP database update:

1) Update data in a MySQL database:
To update data in a MySQL database using PHP, you can use the PDO (PHP Data Objects) library. The following code example demonstrates how to update data in a MySQL database:

$db = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');
$sql = "UPDATE mytable SET column1=:value1, column2=:value2 WHERE id=:id";
$stmt = $db->prepare($sql);
$stmt->bindParam(':value1', $value1);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':id', $id);
$stmt->execute();

2) Update data in a SQLite database:
To update data in a SQLite database using PHP, you can use the SQLite3 library. The following code example demonstrates how to update data in a SQLite database:

$db = new SQLite3('mydatabase.sqlite');
$sql = "UPDATE mytable SET column1=:value1, column2=:value2 WHERE id=:id";
$stmt = $db->prepare($sql);
$stmt->bindParam(':value1', $value1);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':id', $id);
$stmt->execute();

3) Update data in a PostgreSQL database:
To update data in a PostgreSQL database using PHP, you can use the PDO library with the pgsql driver. The following code example demonstrates how to update data in a PostgreSQL database:

$db = new PDO('pgsql:host=localhost;dbname=mydatabase', 'username', 'password');
$sql = "UPDATE mytable SET column1=:value1, column2=:value2 WHERE id=:id";
$stmt = $db->prepare($sql);
$stmt->bindParam(':value1', $value1);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':id', $id);
$stmt->execute();

In conclusion, PHP database update packages provide developers with various options to update data in different types of databases. The choice of the package depends on the specific requirements of the project. Some popular packages include PDO, SQLite3, and pgsql.

PHP DATABASE::update - 1 examples found. These are the top rated real world PHP examples of DATABASE::update 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['h'] = $_POST['h'];
					$data['mip'] = $_POST['m'];
					$data['sprite_id'] = $_POST['sprite_id'];
					if(DATABASE::insert("sprite_frame",$data)) echo "Frame created successfully.";

				break;

				case "edititem":

					$data['name'] = $_POST['name'];
					$data['x'] = $_POST['x'];
					$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>