mysql stored procedure example

This is an example script of mysqls stored procedure.

This will insert a large number of records into a table. I prepared this for checking the performance of db.


delimiter //
CREATE PROCEDURE load_part_tab()
begin
declare v int default 0;
declare latv,longv float;

while v < 8000000
do

set latv = FLOOR(7 + (RAND() * 5)) + rand();
set longv = FLOOR(7 + (RAND() * 5)) + rand();

INSERT INTO `sams`.`latlong` (
`id` ,
`lat` ,
`lng` ,
`place_name`
)
VALUES (
'', latv, longv, concat(latv,longv));

set v = v + 1;
end while;
end
//

delimiter ;

php code for sending email with godaddy using phpmailer

require dirname(__FILE__).'/phpmailer/class.phpmailer.php';

try {

$mail = new PHPMailer(true); //New instance, with exceptions enabled

$body = $content;

$body = preg_replace('/\\\\/','', $body); //Strip backslashes

//$mail->IsSMTP(); // telling the class to use SMTP

$mail->SMTPDebug = 1; // enables SMTP debug information (for testing)

$mail->Host = "relay-hosting.secureserver.net"; // sets GMAIL as the SMTP server

$mail->SetFrom('postman@website.com', 'Postman');

$mail->Subject = $subject;

$mail->AltBody = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test

$mail->MsgHTML($content);

$address = $to;

$mail->AddAddress($address);

if($attachment) {

$mail->AddAttachment($attachment); // attachment

}

$mail->Send();

return true;

} catch (phpmailerException $e) {

//echo $e->errorMessage();

}

get mysql query as html and output to file

MYSQL>> mysql < c:\test.sql -u root database_name -H -e "select * from table ";

take care of php loose comparisons

php has both strict comparison and loose comparison.
see the example.
if("6x"==6)
{
echo "surprice";
}
else
{
echo "i am aware.";
}
in a comparison, if either side has number then both the parameters will be converted to number and will check 6==6, so the output will be "surprice".

In these case, checking with === will work as usual.
eg: if("6x"===6)

Joomla 1.6 alpha released

joomla 1.6 alpha released.

It reduces the narrow advantage of Drupal over Joomla 1.5.

please check this

http://community.joomla.org/blogs/community/1061-joomla-16-alpha-2-released.html

Zencart

Zencart is a pretty easy tool for developing an ecommerce website. A medium level programming knowledge is enough to start because it does not have any complex OOP system to follow. Its not extendable but is highly customizable.

change or reset ples admin password

find this tool through remote desktop connection ,

C:\Program Files\Parallels\Plesk\admin\bin\plesksrvclient.exe

click on that, and it will ask for a new password.