+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Database Server Error - While using mysql_real_escape_string (/showthread.php?tid=52601)
Database Server Error - While using mysql_real_escape_string - El Forum - 06-18-2012
[eluser]Shiju S S[/eluser]
I have a update statement
Code:
$query="UPDATE sellproperty set
c_property_type='$propertycode',c_district='$district',
c_taluk='$subdist',c_location='$location',
c_titile='".mysql_real_escape_string($title)."', c_discription='".mysql_real_escape_string($description)."',
c_building_size='$buildingsize')Quote:A PHP Error was encountered
Severity: Warning
Message: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Filename: common/property.php
Line Number: 457
I have another insertion query working fine in the server also.
Code:
$query="insert into sellproperty (n_slno,n_id,c_property_id,c_status, c_property_type,c_district,c_taluk,c_location,c_titile,c_discription)
values
('$maxtabvalue','$exeid','$propid','Y','$propertycode','$district','$subdist','$location',
'".mysql_real_escape_string($title)."','".mysql_real_escape_string($description)."');