sending variables to table PHP SQL

Question

im trying to send my variables to table but i get error for $title and $body:

Undefined variable: title in C:\wamp\www\source\pishnahad.php on line 237

Notice: Undefined variable: body in C:\wamp\www\source\pishnahad.php on line 237

<div class='container' dir="rtl" >
<label for='name'>نام: </label>
<input type='text' name='name' id='name' value='<?=  $fgmembersite->UserFullName() ?>' maxlength="50"  disabled="disabled"/><br/>

</div>


<div class='container' dir="rtl" >
<label for='email'>ایمیل: </label>
<input type='text' name='email' id='email' value='<?= $fgmembersite->UserEmail() ?>' disabled="disabled"/><br/>

</div>

<form name="form2" method="post" action="submit_shekayat" accept-charset='UTF-8'>
<div class='container' dir="rtl" >
<label for='title'>موضوع: </label>
<input type='text' name='title' id='title'/><br/>

</div>

<div class='container' dir="rtl" >
<label for='body'>توضیحات: </label> <br />
<textarea name="body" id="body" cols="" rows="" style="width:300 ;height:300"></textarea>

</div>

            <?php

$user_id =$fgmembersite->UserID();

$db_host = 'localhost';
$db_name= 'site';
$db_table= 'shekayat';
$db_user = 'root';
$db_pass = '';




$con = mysql_connect($db_host,$db_user,$db_pass) or die("خطا در اتصال به پايگاه داده");

mysql_query("SET NAMES 'utf8'", $con);
mysql_query("SET CHARACTER SET 'utf8'", $con);
mysql_query("SET character_set_connection = 'utf8'", $con);

$selected=mysql_select_db($db_name, $con) or die("خطا در انتخاب پايگاه داده");
mysql_query("SET CHARACTER SET  utf8");
$ins="INSERT INTO $db_table (user_id,title,body) VALUES('$user_id','$title','$body')";
$saved=mysql_query($ins );
mysql_close($con); 
?>


<div class='container'>
<input type='submit'  name='Submit' value='ارسال اطلاعات' />


</div>

You have no such values as $title and $body ?!?

Dimitar Stoyanov
– Dimitar Stoyanov

2015-11-01 14:48:18 +00:00
Commented Nov 1, 2015 at 14:48 — Dimitar Stoyanov
– Dimitar Stoyanov, Commented Nov 1, 2015 at 14:48

Maytham Fahmi · Accepted Answer · 2015-11-03 19:28:31Z

1

I solved my problem, myself.

We should use of two pages:

Sending input boxes via form to another page.
Insert input boxes via these codes:

$ins="INSERT INTO $db_table (user_id,title,body) VALUES('$user_id','" . mysql_escape_string($_POST['title']) . "','" .
mysql_escape_string($_POST['body']) . "')";

edited Nov 3, 2015 at 19:28

Maytham Fahmi

33.2k17 gold badges132 silver badges159 bronze badges

answered Nov 1, 2015 at 15:03

sammy

7094 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dimitar Stoyanov · Accepted Answer · 2015-11-01 14:49:20Z

0

You have the

 $user_id = $fgmembersite->UserID();

But where

 $title

and

 $body

come from ? If you want to assign $body a value of the textarea with the ID body you have to use JS Ajax call for example or simply hardcoding it (which is not recommended).

answered Nov 1, 2015 at 14:49

Dimitar Stoyanov

3491 silver badge7 bronze badges

2 Comments

sammy Over a year ago

here is title and body: <div class='container' dir="rtl" > <label for='title'>موضوع: </label> <input type='text' name='title' id='title'/><br/> </div> <div class='container' dir="rtl" > <label for='body'>توضیحات: </label> <br />

Dimitar Stoyanov Over a year ago

They are HTML elements. You can't simply that say $body. I suppose you have some missunderstanding between html php and ...

Collectives™ on Stack Overflow

sending variables to table PHP SQL

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related