Sql injection protection avoid sql injection techniques

SQL Injection: Tutorial Part 1

http://digitalpbk.blogspot.com/2009/06/hacking-sql-injection-tutorial.html SQL Injection: Tutorial Part 1 SQL InjectionWhat? What is SQL ? SQL stands for Structured Query Language, It is the most widely used database querying language. Before reading on I must say that this is an old technique and I dint want this to be posted because most sites have patched up this hole. I am posting this for the few websites I came across that had this vulnerability. If you have a website or planning to build one or administrates one please read on and fix the security holes ...

Protect yourselves from phishing

http://digitalpbk.blogspot.com/2007/01/get-smart-against-phishing.html Protect yourselves from phishing Phishing? Haven't heard that...Phishing is very similar to fishing. In fishing, we put a bait and wait for the fish to catch it. In Phishing, a fraudsters acting as a genuine bank employee or web admin, sents you an email (the bait) asking for confidential and personal data, that could potentially harm you (Its not nice to see your savings balance to drop to ZERO, right?)Fraudsters are getting smarter and equipping with techniques that almost fool you. So ...

Select random rows from a table in MySQL

http://digitalpbk.com/mysql/select-random-rows-table Select random rows from a table in MySQL In order to select a random row from MySQL, we can order the rows by a random number and then pick the first row. SELECT * FROM node ORDER BY rand() limit 1; The above query randomly selects a row from the table node. MySQL Software ...

Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty

http://digitalpbk.com/perl/solve-netmysql-hang-problem-if-database-result-has-only-1-row-or-empty Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty Net::MySQL is a simple MySQL perl Client to connect to MySQL servers. But Net::MySQL hangs if your result set is having just one row. Sample Net::MySQL code #!/usr/bin/perl use Net::MySQL; $mysql = Net::MySQL->new( hostname => 'localhost', database => 'db', user => 'user', password => 'password', ); $gid = 1; $mysql->query('SELECT * FROM table ...

Extracting embedded Album art in mp3

http://digitalpbk.blogspot.com/2007/01/extracting-embedded-album-art-in-mp3.html Extracting embedded Album art in mp3 AboutThis command line tool extracts embedded album art pictures from mp3's. It extracts only album art that is within the mp3 file. External album arts need not be extracted as they are plain files and can be seen in respective folders, by unchecking the "Hide protected operating system files" in view Tab in Folder Options in Windows XP.(Tools > Folder Options > View Tab)DownloadDownload as zip (38.3 KB)(I Assert that it is not a virus ...

Apache Solr MySQL Sample Data Config

http://digitalpbk.com/apachesolr/apache-solr-mysql-sample-data-config Apache Solr MySQL Sample Data Config ApacheSolr is an indexing server from apache. It is written in Java and can be used to make search pages on your website. Most Websites use a MySQL database to store its data and standard MySQL search using SQL or FULLTEXT Searching by MySQL. But with ApacheSolr we can not only search but also improve the search results. Solr recognizes plurals and similar words like read, reading or A-DATA, adata etc. Therefore Solr returns more efficient search results ...

How to change root admin user password in Drupal ?

http://digitalpbk.com/drupal/how-change-drupal-root-user-password How to change root admin user password in Drupal ? In order to reset the root or superadmin password on a drupal system, login into the database by looking at the settings.php. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line. Run the following query to reset the password. UPDATE users SET pass = MD5('password') WHERE uid = 1 The user id of administrator is always 1. Password field in drupal is stored as MD5 of the actual string password. So ...

Select second largest value in a column using SQL

http://digitalpbk.com/interview-questions/select-second-largest-value-column-using-sql Select second largest value in a column using SQL None The answer is pretty simple without jumping over hoops or thinking about taking MAX etc. SELECT value FROM table ORDER BY value DESC LIMIT 1,1 Why LIMIT 1,1 ? Shouldnt it be 2,1 Think again. LIMIT 0,1 is the first record. Interview Questions ...

Windows 7 showing Different Installed (4 GB) and Usable Memory (2.96 GB)

http://digitalpbk.com/hardware/different-installed-usable-memory-windows-7 with shared memory of 1 GB. Therefore only 2.96 GB of the RAM is usable by the processes. It is better to buy graphics cards with Dedicated memory even if the memory size is less than that is being shared from RAM. This is because, in shared memory the memory buses might be mostly occupied by the graphics system that can slow the system down. In dedicated memory this problem is avoided because the RAM is not touched for graphics rendering and hence the bus is free for your processes. Laptop Windows ...

Introduction to XSS Part 1

http://digitalpbk.blogspot.com/2006/12/introduction-to-xss-part-1.html 2 : Javascript injectionThe next thing you try to do is put javascript into those areas which appear on the site. For example alert("hi");Most probably it wouldn't have work, because either you tried it on some well known site or you have to enter a little more code. Take the following example:The following page has an XSS hole http://www.propmart.com/search/pm_IdSearch.asp?txtPropertyId=somesearchitemBut if you put ...