Web Programming Tutorial

 Go to you xampp  server directories \ 1) opened the  MySQL folder there in the xampp  2)Go the bin folder is here  3)  Search this  mysql_upgrade.exe executable file in the bin directory 4) Run this file is here 5) hopefully Now its working fine

Remember the following steps.these are the following    Open your Windows Command Prompt Go to your project Dir. wamp or xampp where your project place  www/vtiger/vtlib/tools run php -f console.php 1) Create New Module  2)Create new Layout  3)Create new language pack 4)Create new test language pack  5)Import modules  6)update module 7)Remove Module Then Enter you choice 

  his way I'm able to run the PHP programs finely but I want to run the same program from   Windows Command Prompt For it I done following steps : Went to  Advanced System Settings  (Control Panel\System and Security\System\Advanced System Settings) Then clicked on  Environment Variables Then selected the variable  Path Then clicked  Edit...  button Then after the ending semicolon of existing string I added the string  "C:\xampp\php"  by adding a  blank space  after the semicolon. Skip to Step 4 by  left clicking  the  Windows Start Button  and then immediately type  system env , windows search will suggest  Edit the system environment variables , Click this and and go to step 4. Right Click Windows Start  Button, Select  System Click on  System Information Click on  Advanced System Settings Click on  Environment Variables Select  PATH  under  System Variable...

   default Debugging error in the Vtiger. Database Debugging 50% of all problems are a result of corrupt or wrong database queries. There is a fast an easy way to recognize this and get a detailed output, where you need to search for the issue. Also this information helps support persons of module providers to get a more detailed error description. Open the file  include/database/PearDatabase.php Search the line  $adb->connect();  (At the end of the file) You have 2 options in this situation: Add the line: $adb->setDebug(true); This line will output EVERY Query sent to the database. The last one will be the corrupt one and you get an error description, when an error happens. Sometimes it will be helpful to get all queries and also see queries, before the exception Add the line: $adb->setDieOnError(true); This line will output only a detailed error report if a query generates an database error. This works better for module support, because you don’t need...

The first thing we need to look at is that MySQL is a resource and MySQLi is an object. To migrate our code, we really do not need to understand the technical difference, however we must understand that they are different. The first thing we usually do with MySQL is to connect to and select a database, so let's take a look at mysql_connect and mysql_select_db. $connection = mysql_connect( 'host', 'username', 'password', new_link,flags); $database = mysql_select_db( 'database', $link); $connection is a MySQL link identifier to the resource and $database is just a boolean variable that will contain true on success or false on failure. In most situations your host will be localhost and you will only have supplied your username and password. mysqli_connect in PHP Now let's take a look at its counter-part in MySQLi, mysqli_connect. $connection = mysqli_connect( 'host', 'username', 'password', 'database', 'port',...