How to store textarea value in database in PHP

Ahsan Zameer

7 years ago

As a PHP beginner, I know the pain of saving form values in database. But don’t worry in this tutorial I am going to to store textarea value in database.

This tutorial is for beginner you can easily learn and implement in your future web development projects.

Also Read: Insert data in Mysql using Php Form

Store textarea value in database in PHP

I will create only one input field and store in mysql database. This process involves following steps.

Create HTML form and set method attribute value as POST.
Apply some css to the form for better look.
When forms submit get textarea and trim extra spaces from it.
Save into the Mysql Database.
If textarea saves successfully then show success msg.

Create Database:

Create database demo;

1	Create database demo;

Create Database Table:

CREATE TABLE `textarea_value` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`textarea_content` TINYTEXT NULL,
	PRIMARY KEY (`id`)
)
ENGINE=InnoDB
;

CREATE TABLE `textarea_value` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`textarea_content` TINYTEXT NULL,

PRIMARY KEY (`id`)

)

ENGINE=InnoDB

;

Database Connection:

<?php 
$conn = mysqli_connect('localhost','root','','demo');

if(!$conn)
{
	die(mysqli_error());
}
?>

<?php

$conn = mysqli_connect('localhost','root','','demo');

if(!$conn)

{

die(mysqli_error());

}

HTML:

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">

<label>Textarea:</label>
<div>
    <textarea rows="10" cols="60" name="content" required></textarea>
</div>

<input type="submit" name="submit" value="Submit">
</form>

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">

<label>Textarea:</label>

<div>

</div>

</form>

In the above form, action attribute has $_SERVER['PHP_SELF'] which means form will post on the same page. If you don’t want to use $_SERVER['PHP_SELF'] then leave action attribute blank.

CSS:

body{
	font-family:verdana;
}

label{
	font-weight:400;
	margin:10px 0px;
	display:block;
	color:#ee0000;
}

textarea{
	border:1px solid #eeeeee;
}

input[type=submit]{
	background:#ee0000;
	border:1px solid #ee0000;
	color:#ffffff;
	height:30px;
	display:block;
	margin:10px 0px;
}

input[type=submit]:hover{
	background:#ff5858;
	border:1px solid #ff5858;
	cursor:pointer;
}

.success-msg{
	background:#15a869;
	border:1px solid #15a869;
	color:#ffffff;
	width:33%;
}

body{

font-family:verdana;

}

label{

font-weight:400;

margin:10px 0px;

display:block;

color:#ee0000;

}

textarea{

border:1px solid #eeeeee;

}

input[type=submit]{

background:#ee0000;

border:1px solid #ee0000;

color:#ffffff;

height:30px;

display:block;

margin:10px 0px;

}

input[type=submit]:hover{

background:#ff5858;

border:1px solid #ff5858;

cursor:pointer;

}

.success-msg{

background:#15a869;

border:1px solid #15a869;

color:#ffffff;

width:33%;

}

Also Read: User Registration in PHP

Success Message:

<?php 
	if(isset($successMsg))
	{
		echo "<div class='success-msg'>";
		print_r($successMsg);
		echo "</div>";
	}
?>

<?php

if(isset($successMsg))

{

echo "<div class='success-msg'>";

print_r($successMsg);

echo "</div>";

}

PHP Code on Form Submission:

<?php
if(isset($_POST['submit']))
{
	$textareaValue = trim($_POST['content']);
	
	$sql = "insert into textarea_value (textarea_content) values ('".$textareaValue."')";
	$rs = mysqli_query($conn, $sql);
	$affectedRows = mysqli_affected_rows($conn);
	
	if($affectedRows == 1)
	{
		$successMsg = "Record has been saved successfully";
	}
}
?>

<?php

if(isset($_POST['submit']))

{

$textareaValue = trim($_POST['content']);

$sql = "insert into textarea_value (textarea_content) values ('".$textareaValue."')";

$rs = mysqli_query($conn, $sql);

$affectedRows = mysqli_affected_rows($conn);

if($affectedRows == 1)

{

$successMsg = "Record has been saved successfully";

}

All Code Together:

<?php 
$conn = mysqli_connect('localhost','root','','demo');

if(!$conn)
{
	die(mysqli_error());
}

if(isset($_POST['submit']))
{
	$textareaValue = trim($_POST['content']);
	
	$sql = "insert into textarea_value (textarea_content) values ('".$textareaValue."')";
	$rs = mysqli_query($conn, $sql);
	$affectedRows = mysqli_affected_rows($conn);
	
	if($affectedRows == 1)
	{
		$successMsg = "Record has been saved successfully";
	}
}
?>

<!DOCTYPE html>
<html>
<head>
<title>how to store textarea value in database in php</title>
<style>
body{
	font-family:verdana;
}

label{
	font-weight:400;
	margin:10px 0px;
	display:block;
	color:#ee0000;
}

textarea{
	border:1px solid #eeeeee;
}

input[type=submit]{
	background:#ee0000;
	border:1px solid #ee0000;
	color:#ffffff;
	height:30px;
	display:block;
	margin:10px 0px;
}

input[type=submit]:hover{
	background:#ff5858;
	border:1px solid #ff5858;
	cursor:pointer;
}

.success-msg{
	background:#15a869;
	border:1px solid #15a869;
	color:#ffffff;
	width:33%;
}
</style>

</head>
<body>
	<?php 
		if(isset($successMsg))
		{
			echo "<div class='success-msg'>";
			print_r($successMsg);
			echo "</div>";
		}
	?>
	<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
		
		<label>Textarea:</label>
		
		<div>
			<textarea rows="10" cols="60" name="content" required></textarea>
		</div>
		
		<input type="submit" name="submit" value="Submit">
		
	</form>
</body>
</html>

<?php

$conn = mysqli_connect('localhost','root','','demo');

if(!$conn)

{

die(mysqli_error());

}

if(isset($_POST['submit']))

{

$textareaValue = trim($_POST['content']);

$sql = "insert into textarea_value (textarea_content) values ('".$textareaValue."')";

$rs = mysqli_query($conn, $sql);

$affectedRows = mysqli_affected_rows($conn);

if($affectedRows == 1)

{

$successMsg = "Record has been saved successfully";

}

<!DOCTYPE html>

<html>

<head>

<title>how to store textarea value in database in php</title>

<style>

body{

font-family:verdana;

}

label{

font-weight:400;

margin:10px 0px;

display:block;

color:#ee0000;

}

textarea{

border:1px solid #eeeeee;

}

input[type=submit]{

background:#ee0000;

border:1px solid #ee0000;

color:#ffffff;

height:30px;

display:block;

margin:10px 0px;

}

input[type=submit]:hover{

background:#ff5858;

border:1px solid #ff5858;

cursor:pointer;

}

.success-msg{

background:#15a869;

border:1px solid #15a869;

color:#ffffff;

width:33%;

}

</style>

</head>

<body>

<?php

if(isset($successMsg))

{

echo "<div class='success-msg'>";

print_r($successMsg);

echo "</div>";

}

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">

<label>Textarea:</label>

<div>

</div>

</form>

</body>

</html>