Ramanean’s Blog

Php and MySQL Long Text Problem

Though mysql casting is one of the way to address special characters in the text,there is another simple function which lets  you to do this..
This http://php.net/manual/en/function.mysql-real-escape-string.php  lets you to do this very easily

require_once’config1.php’;
$sn = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $sn);
$a=file_get_contents(”http://www.google.com”);
echo $a;
$a1=”";
//Making Mysql escape string
$query = sprintf(”INSERT INTO `testingtable` ( `no` , `a1` )VALUES (%d , ‘%s’)”,
mysql_real_escape_string($a1,$sn),
mysql_real_escape_string($a,$sn));
//Inserting the [...]

Acobay -the new Social Networking site

Acobay is a  new social networking site but unlike others it’s very different.It’s all about registering yourself and sharing the content with others rather than just adding friends.You can add as many as stuff as you like.It can be from your blog or it can be outside resource as there are no restrictions on it.
To [...]

Adding Two Columns in Excel using a Macro

 First to go Visual Basic Editor follow these steps
1) Press ALT+F11
2)Insert->Module
3)In the Module paste this code

Sub s()
‘Declaring variables
Dim i As Integer
Dim j As Integer
For i = 1 To 100
‘Looping from 1 to 100 Columns
‘Adding contents in Column1 and Column 2
a = Sheet1.Cells(i, 1) + Sheet1.Cells(i, 2)
‘Storing the Result in Column 3
Sheet1.Cells(i, 3) = a
End Sub
This [...]

$7.49 .COM on Godaddy

Here is $7.49 .COM offers on Godaddy
Coupon code: gdr0120q
Use this coupon code to register or renew your .COM domain for $7.49
This offer would expire on January 22nd,2009

Godaddy Special offer till January 31st

$5 off on your order for $50 or more at Godaddy
Coupon code:gdr0124a

$10 off on your Purchase  for $75 or more at Godaddy
Coupon code:gdr0124b
$15  off on your order for $100  or more at Godaddy
Coupon code:gdr0124c
These coupon codes would expire on Jaunry 31st 2009 Midnight

Changing Database in MySQL via command prompt

Usually in Xampp mysql would be in mysql/bin
you can access SQL database through PhpmyAdmin and also through Command Prompt
To access MySQL through Command Prompt
a)First access the mysql/bin folder  via command Prompt
b)Then at command Prompt type

mysql.exe -u ganesh -p
Enter password:
c)It would ask for password.When you type the password it would not be shown at the command [...]