noodlehaus/mysqli_etc

how mysqli_prepare should work

2.0.0 2023-04-03 17:45 UTC

Requires

• php: >= 8.0.0
• ext-mysqlnd: *

MIT

• noodlehaus

• mysqli
• prepared statements
• badphp

README

Cruddy functions under the mysqli pseudo-namespace. Requires PHP 7.1+

$connection = mysqli_connect($host, $username, $password, $database);

# perform an insert
mysqli_insert(
  $connection,
  'INSERT INTO users VALUES (?, ?, ?)',
  $username,
  $email,
  $password
);

# perform an update/delete
mysqli_update(
  $connection,
  'DELETE FROM users WHERE username=?',
  $username
);

# perform a fetch
mysqli_select(
  $connection,
  'SELECT * FROM users WHERE username=? LIMIT 1',
  $username
);

# create an interpolated sql statement
$statement = mysqli_interpolate(
  $connection,
  'SELECT * FROM users WHERE username=?',
  $username
);
mysqli_stmt_execute($statement);

License

MIT http://noodlehaus.mit-license.org