MSSQL: MYSQL:
Casting string to bigint for MSSQL & MYSQL
MSSQL: MYSQL:
PHP MSSQL PDO
You can download the PDO for sql server here. Next you would want to add the dll or so into your php.ini. ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; extension=php_pdo_sqlsrv_74_ts_x64.dll extension=php_sqlsrv_74_ts_x64.dll
MSSQL search through whole database for a certain string.
/* Reto Egeter, fullparam.wordpress.com */ DECLARE @SearchStrTableName nvarchar(255), @SearchStrColumnName nvarchar(255), @SearchStrColumnValue nvarchar(255), @SearchStrInXML bit, @FullRowResult bit, @FullRowResultRows int SET @SearchStrColumnValue = ‘P042015003648’ /* use LIKE syntax P102004000005 P062005001955 P042011001733 P012009008972*/ SET @FullRowResult = 1 SET @FullRowResultRows = 20 SET @SearchStrTableName = NULL /* NULL for all tables, uses LIKE syntax */ SET @SearchStrColumnName = NULL […]