PHP - Textarea - Displaying Database Code?

Hi Everyone,

Hopefully this will be a quick one.

How would i write each line in a textbox as a new row in a mysql database?

I cant seem to find the solution on google.

Thanks

Good morning to all.

Recently I just read a post here , it's about how to insert different lines from <textarea> to different mysql rows .
http://www.phpfreaks.com/forums/index.php?topic=325239.0

Thanks to AbraCadaver , his code works well.

Quote

$lines = array_map('mysql_real_escape_string', explode("\n", $_POST['textarea']));
$values = "VALUES ('" . implode("'), ('", $lines) . "')";

$query = "INSERT INTO table_name (column_name) $values";


But now if have more than one textarea , such as area1,area2 and area3 , how should change the code so that all data can be inserted into database simultaneously?

Such as data of area1 is for column 1, row 1,
data for area2 is for column2 , row 1,
and data of area3 is for column 3 ,row 1.

Is it possible to make this works?

Thanks for every reply .

Or something like that... I am not sure how to put this..

Anyway, I'll just get started with explaining my problem.

I have an admin-page in which you can delete the comments given on blogs, using checkboxes and clicking on a button with the value 'verwijderenSubmit'. The deletion part works just fine, nothing wrong.

However, I also want to be able to EDIT the comments with an other button called 'bewerkenSubmit', using the same checkboxes that I use for deletion.
Selecting the right CID (CommentID) is no problem, because that works the same as the deletion-part, but selecting the right textarea to update into the database is the problem...

I uploaded a file here with the whole code: http://dhost.info/ddfs/myproblem.html
I escaped the textarea within with square brackets, because otherwise the whole textarea would screw up..
I also added <!-- RELEVANT CODE --> to select the parts that I need to change.

Well, I hope you understand my problem and can help.

Hello dear friends,

If i've database table (my_table) with one field (text)
and i've created form with textarea

Code: [Select]
<form action="#">
<textarea name="text" id="text"></textarea>
<input type="submit" name="Submit" value="Submit">
</form>
I can add any text inside it and save it in my database table
but when i add html codes it also store it perfect but only 2 codes is not 

the closing of form and textarea </form> and </textarea> it not stored and automatically not saved Why !

i mean if i paste inside the above form - textarea the following code for example

Code: [Select]
<form>
<textarea>blah</textarea>
</form>
it will store it as
Code: [Select]
<form>
<textarea>blah


and will not store </form> and </textarea> how then i can add html codes with textarea and form inside it without conflict

thanks

I have a php form in which ,on click of a edit button the contents of that table row will be displayed in a text area (which appears on the click of that edit button).Below the textarear i have a submit and delete button,i can perform any action.Ater performing the save or delete click the text area should be hidden.
this is not happening,tried with js also.


pasting the code below

Code: [Select]
<form name='add_title' method='post' action=''><?php
echo "<br><br>";

if(isset($_POST['update'])) 
{
if(isset($_GET['id'])) {
$id    = $_GET['id'];
$comments=$_POST['comment'];
$query1 = "update  comments set  comments='$comments' WHERE id = '$id' ";

$result = mysql_query($query1);
//$row=mysql_fetch_row($result);

}
}
if(isset($_POST['delete'])) 
{
if(isset($_GET['id'])) {
$id    = $_GET['id'];
$comments=$_POST['comment'];
$query1 = "delete from  comments  WHERE id = '$id' ";

$result = mysql_query($query1);


}
}
$query="select count(*) from comments";
$result =mysql_query($query);
$row=mysql_fetch_row($result);
$count= $row[0];
if($count!=0)

{
$query="select *from comments order by id desc";
$result=mysql_query($query);
echo "<table width='700' align='center' border=1><tr bgcolor='green' align='center'><td><font color='black'>&nbsp;SlNo&nbsp;</font></td><td><font color='black'>Comment</font></td><td><font color='black'>&nbsp;&nbsp;Date Posted&nbsp;&nbsp;</font></td><td>Edit/Delete</td></tr></b>";
while($row = mysql_fetch_row($result))
{
$d=$row['0'];
$id=$row['0'];
$name=$row['1'];
$date_uploaded=$row['3'];
  
echo  "<td>$id</td><td>$name</td>".
 "<td>$date_uploaded</td>".
 "<td><a href='edit_comments.php?id=$id'>Edit </a></td>".
 "</tr>";
}
if(isset($_GET['id'])) 
{

$id    = $_GET['id'];

$query = "SELECT comments FROM comments WHERE id = '$id' ";

$result = mysql_query($query);
$row=mysql_fetch_row($result);

echo"<center><table width='700' border='1'><tr><td >
<textarea name='comment' cols='80' rows='10'>$row[0]</textarea>
<td></tr><tr><td><a href='edit_comments.php?id=$id'><input type='submit' name='update' id='update' value='Save'></a><a href='edit_comments.php?id=$id'><input type='submit' name='delete' id='delete' value='Delete'></a>
</td><td></td></center>";


} 



echo "</table>";



} else
{
echo "<table width='700' align='center'><tr bgcolor='white' align='center'><td><font color='red' size=2>No comments for  you.</font></td></tr></table>";
}
?>

Edit: Please use [code][/code] tags when posting code.

hi, I have some HTML to edit in my database, in my back end administration I have it in a textarea but when I go to edit it, it all messes up and lots of  '/' area added, see below:

Code: [Select]
Site Design by: <a href=\\\\\\\"http://www.jbiddulph.com\\\\\\\" target=\\\\\\\"_blank\\\\\\\" title=\\\\\\\"John Biddulph - Web Development\\\\\\\">jbiddulph.com</a>
php code Code: [Select]
<p>
<label>Site Design by</label>
<textarea class="text-input small-input" name="SiteDesignby"><?php echo $row1['SiteDesignby'] ?></textarea>
</p>


someone suggested adding this to my page:
SiteDesignby.value = SiteDesignby.value.replace(/\\*."/g,'"');

I added the code and nothing changed!
Can anyone help please?

I want my mysql database to be displayed across the screen similar to the below

Entry 1        Entry 2             Entry 3         Entry 4      Entry 5

eventually with a image above the name, but for now just as above.

 

How would I go about this?

 

I'm having a problem with some php code that allows you to edit a text file. No matter what file it loads, it always adds four horizontal tabs and two spaces to the end of the text. I've attached the code to this post.

If anyone can help me with this, it would be greatly appreciated.

Cindy

Hi,
I'm trying to joing two tables together, in the resulting PHP coding (See below)  the issue I'm having the coding saying select the colour from the colour table where the model of car is the same as the model in the cars table. For example, if the car model is KA and in the table it is KA show the colours.

I know this manual fix does the trick.

[
$test = "KA";
$query_cols = "SELECT * FROM colours WHERE colours.model = '$test' ";
]



But not the soultion any help would be much appericated thank you.


[
include "connections/dbconnect.php";
               $manfactures = "Ford";
               $car_query = "SELECT * FROM cars WHERE make = '$manfactures'";                  
               $car_result = mysql_query($car_query) or die ("Error in query: $car_query. ".mysql_error());
               
               setlocale(LC_MONETARY, 'en_GB');
               $fmt = '%i';
               if (mysql_num_rows($car_result) > 0)
               {
                  
                  
                  
                  while ($car_row = @ mysql_fetch_array($car_result))
                  {
                     
                     $test = "KA";
                     $query_cols = "SELECT * FROM colours WHERE colours.model = cars.model";
                     $cols_result = mysql_query($query_cols) or die ("Error in query: $query_cols. ".mysql_error());
                     print "
                           <table class='details'>
                              <tr>
                                 <td rowspan='2'>
                                    <img src=\"". $car_row["image"] ."\" alt='" . $car_row["image_alt"] . "' />
                                 </td>
                                 <td colspan='2'>
                                    <a href='" . $car_row["what_link"] . "'>
                                       " . $car_row["model"]." ".$car_row["model_details"] . "
                                    </a>
                              </tr>
                              <tr>
                                 <td>
                                    <p class='info'>
                                       RRP:<br/>
                                       What Price:<br/>    
                                       Our Price:<br/>
                                       Savings of:<br/>
                                       Delivery Time:
                                       
                                    </p>
                                 </td>
                                 <td>
                                    <p class='info1'>
                                 ";
                                       echo money_format($fmt, $car_row["rrp"] );
                             print "<br/>";
                           
                                       echo money_format($fmt, $car_row["what_price"] );
                             print "<br/>";
                           
                                       echo money_format($fmt, $car_row["our_price"] );
                           
                             $savings = $car_row["rrp"] - $car_row["our_price"];
                             print "       <br/>
                                       <font color=\"red\">";
                                          echo money_format($fmt, $savings );
                             print "       </font><br/>
                                       " . $car_row["delivery_time"] . "
                                    </p>
                                 </td>
                              </tr>
                              <tr>
                                 <td>
                                 ";
                                    while ($cols_row = @ mysql_fetch_array($cols_result))
                                    {
                              ?>
                                               

                                                <a href='#' onmouseout='hideTooltip()' onmouseover='showTooltip(event,"<?php print "" . $cols_row["colour"] . ""; ?>");return false'>
                                      <?php
                                          print "                                                
                                                <img src=\"". $cols_row["colour_img"] ."\" alt='" . $cols_row["colour_img_alt"] . "' />
                                               ";
                                    }
                          print "
                                 </td>
                              </tr>
                              ";   
                  }                           
               }
               
   
               else
               {
                  echo "Aids!";
               }
               print "</table>";                     

                        
                           ?>]

So I have an simple account centre up, and i'm wanting to display their 'Name' 'Username' and 'Email' as part of their details. But I have one problem... My code doesn't seem to be getting the data from my database...

It may be messy to some people, just warning you!

Code: [Select]
<?php

session_start();

if($_SESSION['username']){

$connect = mysql_connect("****","****","****") or die("Could not connect to database.");
mysql_select_db("****") or die ("Could not find database!");

$sql = mysql_query("SELECT * FROM login");

$username = $rows['username'];
$email = $rows['email'];
$rows = mysql_fetch_assoc($sql);

echo "<p>";
}
else
header("location: suggestion.html");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
body {
background-color: #CCC;
}
body,td,th {
color: #000;
font-family: "MS Serif", "New York", serif;
}
</style>
</head>
<body>
<div id="wrap">
<!--Header-->
    <div id="header_member">
   
    </div>
   
    <!--Log out and time-->
        <div id="info">
<div id="date"><script type="text/javascript">
var currentDate = new Date()
  var day = currentDate.getDate()
  var month = currentDate.getMonth() + 1
  var year = currentDate.getFullYear()
  document.write("<b>" + day + "/" + month + "/" + year + "</b>")
  var currentTime = new Date()
  var hours = currentTime.getHours()
  var minutes = currentTime.getMinutes()</script>
     </div>
             
           
             
        <div id="time"><script type="text/javascript">
var suffix = "AM";
  if (hours >= 12) {
  suffix = "PM";
  hours = hours - 12;
  }
  if (hours == 0) {
  hours = 12;
  }

  if (minutes < 10)
  minutes = "0" + minutes

  document.write("<b>" + hours + ":" + minutes + " " + suffix + "</b>")</script>
          </div>
          </div>
         <div id="logout"><center><?php echo "<a href='logout.php'>Log out.</a>";?></center></div>
         
  <!--Main section which will contain everything else-->
  <div id="member_main">
             
           <div id="member_right"><center>
             <p><img src="images/accountinf.png" width="175" height="30" /></p>
             <p>Name: <?php echo $username;?></p>
             <p>Email: <?php echo $email;?></p>
               </center>

        </div>
               
   <div id="member_top"><center><?php echo "Welcome, ".$_SESSION['username'];?></center></div>
                   
               <div id="member_left" align="center"><img src="images/navigation.png" width="105" height="30" /><img src="images/home_member.png" width="105" height="30" /><img src="images/account.png" width="105" height="30" /></div>
          </div>
             
<!--Footer-->         
<div id="footer_member"></div>           
</div>

</body>
</html>

I create list box which value contains from the table of database
but now i want to display the data related to the value of list box.
please any body can help me to solve the problem

My table contains id, category_name, title, discription
and list box contain the value from the filed category_name of the table
now i want to display title and discription according to the category_name.

please send me code
i am totally confused..

PHP Code
Code: [Select]

<?php
$username="";
$password="";
$database="";

mysql_connect("","","");
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1-name=mysql_result($result,$i,"id");
$field2-name=mysql_result($result,$i,"Location");
$field3-name=mysql_result($result,$i,"Property type");
$field4-name=mysql_result($result,$i,"Number of bedrooms");
$field5-name=mysql_result($result,$i,"Purchase type");
$field6-name=mysql_result($result,$i,"Price range");

echo "<b>$field1-name 
$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

$i++;
}

?>

HTML code for the form
Code: [Select]

<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

<td><p class="PT">Property type:</p></td>
<td><div id="PS">
<form action="insert.php" method="post">
<select name="property type" style="width: 170px;">
<option value="none" selected="selected">Any</option>
<option value="Houses">Houses</option>
<option value="Flats / Apartments">Flats / Apartments</option>
</select>
</form>
</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post">
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">
<form action="insert.php" method="post">
<select name="number of bedrooms">
<option value="none" selected="selected">No Min</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select> to

<select name="number of bedrooms">
<option value="none" selected="selected">No Max</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</form>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">
<form action="insert.php" method="post">
<select name="price range">
<option value="none" selected="selected">No Min</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>
</select> to

<select name="price range">
<option value="none" selected="selected">No Max</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>

</select>
</form>
</div>
</td>


</tr>

</table>

</div>
<form id="submit" action="">
      <input type="submit" value="search" />
      </form>

So I've followed this code, corrected about 12 error, talked to my hosting and I am so done. I have tried everything but the error won't go away. The code is pasted below. As it's really late any help would be appreciated that would make my day the next day...    <?PHP

I am trying to display data from a database from a form entry

here is the php

<?php
include('dbconnect.php');

@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM child_info";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1-name=mysql_result($result,$i,"file_number");
$field2-name=mysql_result($result,$i,"first_name");
$field3-name=mysql_result($result,$i,"middle_name");
$field4-name=mysql_result($result,$i,"last_name");
$field5-name=mysql_result($result,$i,"birthdate");
$field6-name=mysql_result($result,$i,"gender");
$field7-name=mysql_result($result,$i,"features");
$field8-name=mysql_result($result,$i,"diagnosis");
$field9-name=mysql_result($result,$i,"description");
echo "<b>$field1-name
$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

$i++;
}

?>

here is the form I am using

<form name="child_info" action="selectdata.php" method="post"  id="child_info">
                       <table width="444" align="center" >
         <tr>
                                    <td>
                                       Search by Name:
                                    </td>
                                    <td>
                                       First Name:<input type="text" class="form-textbox " id="first_name" name="first_name" size="20" /><br />
                                        Last Name:<input type="text" class="form-textbox " id="last_name" name="last_name" size="20" />
                                    </td>
                                </tr>
                               <tr>
                                   <td width="208">
                                       Choose Male or Female:                                    </td>
                                <td width="224">
                                    <input type="radio" name="gender" value="male" />
                 Male
                 <input type="radio" name="gender" value="Female" />
                 Female                                  </td>
                            </tr>
                            <tr>
                               <td>
                                   Choose age range:                               
                                </td>
                                <td>
                                   <select name="first_age" id="first_age">
                                  <option value="00">From</option>
                                  <option value="1">1</option>
                                  <option value="2">2</option>
                                  <option value="3">3</option>
                                  <option value="4">4</option>
                                  <option value="5">5</option>
                                  <option value="6">6</option>
                                  <option value="7">7</option>
                                  <option value="8">8</option>
                                  <option value="9">9</option>
                                  <option value="10">10</option>
                                  <option value="11">11</option>
                                  <option value="12">12</option>
                                  <option value="13">13</option>
                                  <option value="14">14</option>
                                  <option value="15">15</option>
                                  <option value="16">16</option>
                                  <option value="17">17</option>
                                  <option value="18">18</option>
                                </select>
                                 <select name="second_age" id="second_age">
                                  <option value="00">To</option>
                                  <option value="1">1</option>
                                  <option value="2">2</option>
                                  <option value="3">3</option>
                                  <option value="4">4</option>
                                  <option value="5">5</option>
                                  <option value="6">6</option>
                                  <option value="7">7</option>
                                  <option value="8">8</option>
                                  <option value="9">9</option>
                                  <option value="10">10</option>
                                  <option value="11">11</option>
                                  <option value="12">12</option>
                                  <option value="13">13</option>
                                  <option value="14">14</option>
                                  <option value="15">15</option>
                                  <option value="16">16</option>
                                  <option value="17">17</option>
                                  <option value="18">18</option>
                                </select>
                              </td>
                            </tr>
                            <tr>
                               <td>
                                </td>
                                <td>
                                </td>
                            </tr>
                            <tr>
                               <td>
                                </td>
                                <td>
                                    <div align="right">
                                      <input type="submit" name="submit" id="submit" value="submit" />
                                      <input type="reset" name="reset" id="reset" value="reset" />
                                       </div></td>
                            </tr>
                          </table>
                    </form>

first problem is getting the form to use the php

second problem is when i try to use the php alone is I get this error

Parse error: syntax error, unexpected '=' in /home/fathersh/public_html/selectdata.php on line 17   17 is highlighted above in the php