Don’t use @@Identity to select the ID of the newly inserted record, use scope_identity() instead. @@Identity returns the most recently created identity for your current connection. When you first use it, it might be fine, but if someone adds a trigger that causes another identity to be created, that one will be the one which […]
Don’t use @@Identity Read More »
More reference: http://www.sitepoint.com/parsing-xml-with-simplexml/ Given the XML: <Calendar> <Account> <Name>Sample Account Name</Name> <Client>Test User</Client> </Account> <CalendarDates> <CalendarDate> <Date>2014-03-01</Date> <Events> <Event> <Name>Event Number One</Name> <StartingAt>2014-03-01T09:30:00</StartingAt> <Categories>General</Categories> </Event> <Event> <Name>Another Event</Name> <StartingAt>2014-03-01T09:30:00</StartingAt> <Categories>Meeting</Categories> </Event> <Event> <Name>Hockey Game</Name> <StartingAt>2014-03-01T10:00:00</StartingAt> <Categories>Sports</Categories> </Event> </Events> </CalendarDate> </CalendarDates> </Calendar> Perhaps this was entered into a textarea on a form and we have read
INCOMPLETE – Parsing XML with SimpleXML and PHP Read More »
From: http://www.sitepoint.com/ten-quick-fixes-reduce-page-weight/?utm_source=dlvr.it&utm_medium=facebook You may need to use tools such as Chrome’s Audit Developer Tool, JSLint, Dust-Me Selectors, CSS Usage, unused-css.com or build tools such as grunt-uncss.
Get rid of unwanted CSS and Javascript Read More »
Loop through PHP Request Values In order to Loop through PHP Request Values – GET and POST without knowing what they all might be, you can simply use the following code: foreach ($_REQUEST as $key => $value) { $value = mysql_real_escape_string( $value ); $value = addslashes($value); $value = strip_tags($value); if($value != “”){$requestnumber ++;} echo $key.
Loop Through PHP Request Values – GET and POST Read More »
