mysql - How Apostrophe is stored in database using php form text area? -


i have code file name of "form.php". in create web form , using text area tag in it. have problem. when write in text area , use apostrophe in text data can not store in database. when write text without apostrophe data stored in database. how can fix problem?

my code below:

<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"><?php $connection = mysql_connect("localhost", "root", ""); // establishing connection server $db = mysql_select_db("aaaaa", $connection); // selecting database server if(isset($_post['submit'])){ // fetching variables of form travels in url $txttitle = $_post['txttitle']; $txtreferance = $_post['txtreferance']; $txttoname = $_post['txttoname']; $chkconfidential = $_post['chkconfidential']; $txttodesignation = $_post['txttodesignation']; $txtdate = $_post['txtdate']; $cmbsolutation = $_post['cmbsolutation']; $txttoentity = $_post['txttoentity']; $txttoadd1 = $_post['txttoadd1']; $txtthankyou = $_post['txtthankyou']; $txttoadd2 = $_post['txttoadd2']; $cmbyourstruely = $_post['cmbyourstruely']; $txttoadd3 = $_post['txttoadd3']; $txtsignaturename = $_post['txtsignaturename']; $txttocity = $_post['txttocity']; $cmbsdesignation = $_post['cmbsdesignation']; $txtheading1 = $_post['txtheading1']; $txtench1 = $_post['txtench1']; $txtheading2 = $_post['txtheading2']; $txtench2 = $_post['txtench2']; $txtheading3 = $_post['txtheading3']; $txtench3 = $_post['txtench3']; $txtrational = $_post['txtrational'];   //insert query of sql $query = mysql_query("insert test(file_name, ref_no, to_name, confidential, designation, date, solutation, entity, add_1, thank_you, add_2, yours_truly, add_3, sign_name, city, s_designation, heading_line_1, encl_line_1, heading_line_2, encl_line_2, heading_line_3, encl_line_3, text)   values       ('$txttitle', '$txtreferance', '$txttoname', '$chkconfidential', '$txttodesignation', '$txtdate', '$cmbsolutation', '$txttoentity', '$txttoadd1', '$txtthankyou', '$txttoadd2', '$cmbyourstruely', '$txttoadd3', '$txtsignaturename', '$txttocity', '$cmbsdesignation', '$txtheading1', '$txtench1', '$txtheading2', '$txtench2', '$txtheading3', '$txtench3', '$txtrational')"); echo "<br/><br/><span>data inserted successfully...!!</span>"; } else{ echo "<p>insertion failed <br/> fields blank....!!</p>"; }  //mysql_close($connection); // closing connection server ?>

this you're looking for: mysql_real_escape_string

use on every field escape such characters.

$txttitle = mysql_real_escape_string( $_post['txttitle'] ); // same other columns

ps: use mysqli , mysql deprecated , slow too.


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more