MySQL PHP Exampler

   mysql_connect("localhost", "username", "password") or die(mysql_error());
   mysql_select_db("test") or die(mysql_error());
 
   echo " Step 1. Insert data
";
   $sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was inserted! ";   
   } else {
      echo "An error occured during insert! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 2. Update data
";
   $sql = "UPDATE users SET age=45 WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was updated! ";   
   } else {
      echo "An error occured during update! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 3. Remove data
";
   $sql = "DELETE FROM users WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was removed! ";   
   } else {
      echo "An error occured during remove! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
?>

Asterisk Voice Prompts

you can download asterisk voice prompts in different language using the following link.

http://downloads.asterisk.org/pub/telephony/sounds/

MsSQL dump to remote server

was running out of disk space on a server today. The server had a large database table that was no longer used, so I wanted to archive it and then drop the table. But the server didn’t have enough disk space to dump it out to disk before copying it off to a remote server for archiving.
The first thought was to run mysqldump dump on the destination machine, and to access the database over the network. That however, doesn’t compress or encrypt the data. Plus I would have had to create a mysql user with permission to access the database remotely.
The solution I came up with worked out well: mysqldump directly to the remote host with this command:

mysqldump [mysqldump options] | gzip -c | ssh user@remotehost "cat > /path/to/some-file.sql.gz"

That pipes the mysqldump command through gzip, then to through and SSH connection. SSH on the remote side runs the ‘cat’ command to read the stdin, then redirects that to the actual file where I want it saved.

Audio Format Converter For Asterisk

you can convert audio format for asterisk ivr from the following links.

http://www.digium.com/en/products/ivr/audio-converter.php

other option is to use imagic audio editor or sox