Julius Goh Blog

XAMPP DB Crash fix

It is possible, I found out a solution: Install new xampp Copy your old database folder from xampp\mysql\data\databasefolder to Paste in your running xampp folder C:\xampp\mysql\data After that stop mysql and apache service then...

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

Netbeans PHP Xdebugger

https://www.codewall.co.uk/debug-php-with-xdebug-on-netbeans/ Highlight all of the information on the page and copy it. Go to theĀ XDebug Wizard tool. Paste the information into the Text Box input on the wizard tool page. Locate and click the...

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...

MYSQL search through whole database for a certain string.

The code above will generate a procedure called get_table(SEARCH_STRING) , that will accept 1 parameter which is your string. It will search through the whole database server besides these db(information_schema,test,mysql). But if you would...

Javascript – Event key code cheat sheet

Today i’ve played around with event.keyCode and event.type in javascript and i found this URL that helps alot with boosting our programming for event https://css-tricks.com/snippets/javascript/javascript-keycodes/