Delete rows Delete based on DateTime
Category: Queries
INSERT
Was INSERT sucessful? Get Auto ID Of New Record The insert_id() function returns the auto generated id used in the latest querywith a column having the AUTO_INCREMENT attribute.
INSERT or UPDATE
SELECT
Return Results or False if none Loop through all row results Get single result Is a result returned? Select From Row + Value Array Read SQL Server Time
UPDATE
Simple Update If you need to know whether UPDATE was successful If you need to know how many rows were affected Update From Row + Value Array
$wpdb->prepare
It’s best practice to always use ->prepare to prevent against SQL injection attacks via user supplied data. This is simply a string checker function, string in > string out with variables added as it works. You only need to use it for values you have obtained from somewhere else. You should NOT use it for […]