I have a text area that I am trying to insert about 63 lines of text. This is PHP front end with a mysql backend. I am putting in set lists into the database and I cannot enter all the data. I am wondering what limitations php might have with inserting text into a mysql database.
Here is the php layout
Here is the php code.
Thanks
-How important does a person have to be before they are considered assissinated instead of just murdered?
Here is the php layout
Code:
+-------------+----------
| Field Type |
+-------------+----------
| ID int(11)
| colBand varchar(50)
| colShow varchar(50)
| colSet1 longtext
| colSet2 longtext
| colSet3 longtext
| colSet4 longtext
| colShowInfolongtext
Code:
<html>
<head>
<meta name="GENERATOR" content="SAPIEN Technologies PrimalScript 3.1">
<title>Document Title</title>
</head>
<body>
<form action="setlist.php">
<table>
<tr><td style="font-weight:bold">Band</td>
<td><input type="text" name="Band"></td>
</tr>
<tr><td style="font-weight:bold">Show</td>
<td><input type="text" name="Show"></td>
</tr>
</table>
SET1<textarea name="set1" STYLE="background-color: #E6E6FA;" rows="10" cols="80"></textarea> <br>
SET2<textarea name="set2" STYLE="background-color: #E6E6FA;" rows="10" cols="80"></textarea> <br>
SET3<textarea name="set3" STYLE="background-color: #E6E6FA;" rows="10" cols="80"></textarea> <br>
SET4<textarea name="set4" STYLE="background-color: #E6E6FA;" rows="10" cols="80"></textarea> <br>
Info<textarea name="info" STYLE="background-color: #E6E6FA;" rows="10" cols="80"></textarea> <br>
<input type="submit">
</form>
<?
include('data.php'); //Database information
$band = $HTTP_GET_VARS['Band'];
$show = $HTTP_GET_VARS['Show'];
$set1 = $HTTP_GET_VARS['set1'];
$set2 = $HTTP_GET_VARS['set2'];
$set3 = $HTTP_GET_VARS['set3'];
$set4 = $HTTP_GET_VARS['set4'];
$info = $HTTP_GET_VARS['info'];
echo $band . "<BR>";
echo $show . "<BR>";
echo $set1 . "<BR>";
echo $set2 . "<BR>";
echo $set3 . "<BR>";
echo $set4 . "<BR>";
echo $info . "<BR>";
//createing the sql query
$query = "insert into tblinfo (colBand, colShow, colset1, colset2, colset3, colset4, colShowinfo)
values ('$band', '$show', '$set1', '$set2', '$set3', '$set4', '$info')";
//running the query
mysql_query($query) or die("sql insert failed");
mysql_close($connection);
?>
</body>
</html>-How important does a person have to be before they are considered assissinated instead of just murdered?