Knowledge Sharing

Happy New Year 2011 to everyone, let the new opportunities give a knock to everyone and give all what you want...Have a peaceful and prosperous Year Ahead...CHEERS !!

Hey, Everybody is very keen to make use of the functionality that we have in php. A end product of every web application is reports..without reports its like a waste to have all the functionalities. One most important thing I need to highlight here is if anyone is thinking to extract report out of php then the first step you need to follow is using the BIFF WRITER , this is a excellent set of files used to extract reports in php, just modify your bit and you can take out the report with this hep files very easily. You can modify the headers that you need to send to the excel and then you can send all the data to the excel. While you are creating a new php page for the report generation. DO NOT FORGET TO MENTION or INCLUDE THE BELOW FILES FROM BIFF WRITER require_once('Worksheet.php'); require_once('Workbook.php'); function HeaderingExcel($filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: a

Ok, so another solution which I thought would be cool if I share with other new bees like me using AJAX. I have a new user registration form, I allow users to enter their email IDs, Name, Phone number etc. Now sometimes it is very irritating from the user perspective that they have filled all the lengthy form and then they got to know that their email ID already existed in the database. So, think smartly. Why not to notify the user as soon as he enters the email ID. hmmm !!! Looks cool but how to do it? first of all make a html form and within the email id field make use of the onblur function and call another javascript function like mentioned below. <input type="text" name="Email" onblur="email_chk(2);"/></td> Now the email_chk function in the javascript include this is Head element of your form <PLEASE ALSO DO NOT FORGOT TO INCLUDE THE AJAX.JS FILE WHICH IS REQUIRED TO CALL THE AJAX.CONNECT FUNCTION> <script langu

Hi, As we all are very career conscious in today's fast moving world, is it really necessary to be A MBA to reach on a Good position? Is MBA from a foreign country is more valued than your own country? Is is necessary to leave a company and then opt for a mba? Lets discuss this, please be a active participant. Cheers !!

Solution Sharing (Community to Share Views/Solutions): Dynamically generate Text Box and update its value in database

Hi Guys, This Post is in reference to the time I spent in order to write just a piece of code in PHP, though it would be very easy for most of the guys but if you are still learning then its a good thing to be proud of. Ok let me explain a little about what I was trying to do and how I did it. Requirement : I need to list down all the names of guys who falls under a certain category and display them on another page. I can do this by creating static text box in the landing page and fetch the value from the database OR I can dynamically generate the text box and display all the data there. For that first call the sql query of the condition like this. $sql = mysql_query("SELECT * FROM `list1` WHERE BLAH BLAH"); Now use the While query in order to get all the data required  <?php       while ($row = mysql_fetch_array($sql))       {           ?>       <tr>       <td  align="center" valign="middle" scope="row">