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

Hi All, As we all play around a lot with Excel in our Day to Day tasks, so automating that is a must thing. Below is a code to send the whole excel sheet via email on the click of a button, I know you can find this on various other sites as well, but I am also sharing the same as well. Below is the Macro to send a excel file as a attachment. Sub Send_email() Dim wb As Workbook Dim I As Long Set wb = ActiveWorkbook     If Val(Application.Version) >= 12 Then         If wb.FileFormat = 51 And wb.HasVBProject = True Then             MsgBox "There is VBA code in this xlsx file, there will be no VBA code in the file you send." & vbNewLine & _                    "Save the file first as xlsm and then try the macro again.", vbInformation             Exit Sub         End If     End If     On Error Resume Next            wb.sendmail "xxx@abc.com", _                     "Please find the attached email"               

DOS Attacks or Denial Of Services Attack have become very common amongst Hackers who use them as a path to fame and respect in the underground groups of the Internet. Denial of Service Attacks basically means denying valid Internet and Network users from using the services of the target network or server. It basically means, launching an attack, which will temporarily make the services, offered by the Network unusable by legitimate users. In others words one can describe a DOS attack, saying that a DOS attack is one in which you clog up so much memory on the target system that it cannot serve legitimate users. Or you send the target system data packets, which cannot be handled by it and thus causes it to either crash, reboot or more commonly deny services to legitimate users. DOS Attacks are of the following different types-: 1. Those that exploit vulnerabilities in the TCP/IP protocols suite. 2. Those that exploit vulnerabilities in the Ipv4 implementation. 3 There are also

Stopping by woods on a snowy evening   Whose woods these are I think I know, His house is in the village though. He will not see me stopping here, To watch his woods fill up with snow.   My little horse must think it queer, To stop without a farmhouse near, Between the woods and frozen lake, The darkest evening of the year.   He gives his harness bells a shake, To ask if there is some mistake. The only other sound's the sweep, Of easy wind and downy flake.   The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep.

SugarCRM is the market-leading, commercial Open Source customer relationship management (CRM) application. SugarCRM’s Open Source architecture easily adapts to any business environment by offering a more flexible, cost-effective alternative than proprietary applications. It offers a complete CRM system for businesses of all sizes. For a small business SugarCRM can be a huge time and expense saver. It requires minimal technical knowledge to get it installed and the built in web administration console and backup system allow you to feel comfortable that it’s going to keep running. Core SugarCRM functionality includes sales automation, marketing campaigns, support cases, project mgmt, calendaring and more. Built in PHP, supports MySQL and SQL Server allows it that cool functionality LAMP system. We have tested it Windows XP/Vista/2k3 . Step 1: Installing XAMPP on Windows 1. Go to http://www.apachefriends.org/en/xampp-windows.html#641 and click "XAMPP Windows 1.7.1". Download

How to Create a sub-panel and build relationships on the modules Oqc-Contract, oqc-Offering, oqc_products. Attention: Every time you need to make a change like this it's smart to backup the files to be modified and a backup the database. It must not be done when there are users on-line on the system. The module of OpenQuotesandContracts, can be downloaded at the site of sugarforge in projects, the modules were developed to work with mozzila. This manual will explainain how to create relationship with other modules, also create the sub-panels of these relationships. All customizations are not Upgrade-SAFE, or if made some customization the set up files, should be kept to verify the possibility of having integration with other future versions of sugarCRM. Many to many relationships on sugar CRM are made with some steps. - Define the link of relationship on the vardefs of both modules on the relationship - Create a metadata file with the fields of DB and definition of th

Sugar Version: 5.1 Overview In many cases it is desirable to hide or show certain fields on a form based on the value of a field.   For example, if the account is a “partner” the form should show partnerish fields.   The easiest way to do this is to create panels with information specific to each record type and then hide or show the panels based on the record type. Step 1 – Rearrange the Edit and Detail Views Start with the edit view first.   From Studio, open the account edit view and create 2 panels. Name the first panel “CUSTOMER INFO” and the second panel “PARTNER INFO”.    The naming of these is very important because they will be used in the JavaScript code to hide these panels.   Drag some fields into both panels (See example below) Repeat the process for the detail view ensuring the panel names are the same. Creating a Custom Edit Handler Create a file called custom/modules/Accounts/views/view.edit.php.   This file is a custom edit view handler for the accounts module.