php - Text Area spacing when inserting to database -


so have text area wherein data posted database.

enter image description here

so here image of sample input might like.it has spacing via enter key when send database spacing wont there , display of input

enter image description here

<?php     require("common.php");     if(empty($_session['user']))     {         header("location: login.php");         die("redirecting login.php");     } ?> <?php  $host="localhost"; $username="root"; $password="";  $db_name="phplogin";  $tbl_name="tasks";   mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db");  $ttoday=$_post['comment1']; $task_issues=$_post['comment2']; $ttom=$_post['comment3']; $id=$_post['comment'];  $sql="insert $tbl_name(task_today, issues, task_tom, u_id)values('$ttoday', '$task_issues', '$ttom', '$id')"; $result=mysql_query($sql);  if($result){ header("location: private.php"); exit; }  else { echo "error"; } ?>  <?php // close connection mysql_close(); ?>

here insert codes.

use nl2br(). try this,

$ttoday= nl2br($_post['comment1']);


Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more