Posts

Showing posts from September, 2012

PHP - AJAX and XML

Image
AJAX can be used for interactive communication with an XML file. AJAX XML Example The following example will demonstrate how a web page can fetch information from an XML file with AJAX: Example: The HTML Page looks like as below CD info will be listed here... Example Explained - The HTML Page When a user selects a CD in the dropdown list above, a function called "showCD()" is executed. The function is triggered by the "onchange" event: <html> <head> <script type="text/javascript"> function showCD(str) { if (str=="")   {   document.getElementById("txtHint").innerHTML="";   return;  } if (window.XMLHttpRequest)   {// code for IE7+, Firefox, Chrome, Opera, Safari   xmlhttp=new XMLHttpRequest();   } else   {// code for IE6, IE5   xmlhttp=new ActiveXObject("Microsoft.XMLHTTP

How to make remote connection in database?

The following is the process to make a remote connection in database: Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database. Click on Surface Area Configuration for Services and Connections. Click on SQLEXPRESS/Database Engine/RemoteConnections Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only’ under Local and Remote Connections. Click on OK button / Apply button

MySQL root password recovery

First log in to the system as the same person who is running the mysqld daemon (probably root). Kill the process, using the kill command. Restart MySQL with the following arguments: bin/mysqld Skip-grant USE mysql; UPDATE user SET password = password('newpassword') WHERE User = 'root'; Exit bin/mysqladmin reload The next time you log in, you will use your new password