Pdf read table

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

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

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

Using PHP for more than HTML

http://digitalpbk.blogspot.com/2007/04/using-php-for-more-than-html.html Using PHP for more than HTML IntroIt is mostly thought that PHP can be used only for making dynamic web pages. No. PHP can also be used to make dynamic images (jpg,gif,bmp,png..), javascript codes (js), Style sheets (css), XML files and in the advanced cases pdf's, docs etc.So How do we know the php is a different file ?By default the php file is rendered as a HTML file. The server does not need any recognition for the format of the php file, i.e, server doesn't care what the format is ...

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

ARP Spoofing or IP Masquerade

http://digitalpbk.blogspot.com/2009/02/arp-spoofin-ip-masquerade.html to the MAC addresses in the data link layer. This is accomplished using the ARP (Address Resolution Protocol). In this method when a packet needs to be sent to a destination machine, given its IP, the ARP protocol is used to send an ARP Request. This request is broadcast among the machines on the ethernet. If the machine is within the same ethernet, the MAC address of the corresponding machine is obtained from the machine as an ARP reply. This MAC address is cached by the machine, in an ARP Table ...

The MP3 ID3 Tag

http://digitalpbk.blogspot.com/2007/03/mp3-id3-tag.html location lookup tableOWNE Ownership framePRIV Private framePCNT Play counterPOPM PopularimeterPOSS Position synchronisation frameRBUF Recommended buffer sizeRVA2 Relative volume adjustment (2)RVRB ReverbSEEK Seek frameSIGN Signature frameSYLT Synchronised lyric/textSYTC Synchronised tempo codesTALB Album/Movie/Show titleTBPM BPM (beats per minute)TCOM ComposerTCON Content typeTCOP Copyright messageTDEN Encoding timeTDLY Playlist delayTDOR Original release timeTDRC Recording timeTDRL Release time ...

Base 64 Encoding

http://digitalpbk.blogspot.com/2006/12/base-64-encoding.html in the ASCII code. 64 different characters implies 6 bits as the word length. (no: of bits to represent a character)(2^6=64). So the encoding method is to group the binary data in groups of 6 bits. 10001010010010011110101101010100100100111000101001001001111010110101010010010011Now the grouped 6 bits words are represented by letters, digits and punctuations. A table is defined to denote the mappings of the bit pattern to a corresponding character. Here is a sample of base64 encoding ...

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

Sony Vaio Battery Care utility Download

http://digitalpbk.com/software/sony-vaio-battery-care-utility-download Sony Vaio Battery Care utility Download Sony Vaio Battery Care Function utility is a sony vaio utility which helps improve battery performance by limiting maximum capacity to 80% of the full capacity. Read more about Sony Vaio Battery care function in How to Enable Battery care function on Sony Vaio to improve Battery life. Free download the utility attached with this post. It works with only Sony Vaio. Sony Vaio Software ...