PHP mysql - Display comma separated value from the database in tabular form

Question

I am complete beginner I want to display comma separated values from database in tabular form

From the below image link we can see how the data is getting added separated by commas:

Databaseimage

I want to display in tabular form in html/php page just like below:

Table image

This is my html page below:-

<form action="insert.php" method="POST">

<div id="items">
    <input type="text" placeholder="name" name="user_name[]" />
    <input type="text" placeholder="email" name="user_email[]" />   
</div>

<input type="button" value="add entry" id="add"/>
<input type="submit"  value="submit"/>

Javascript file for adding additional input:-

$(document).ready(function(){

$("#add").click(function (e){
event.preventDefault()
$('#items').append('<div><input type="text" placeholder="Name"   name="user_name[]" ><input type="text" placeholder="email" name="user_email[]">'
+'<input type="button" value="delete" id="delete"/></div>');    

}); 

$('body').on('click','#delete',function(e){
    $(this).parent('div').remove();
});

});

And below is the PHP code for inserting to database:-

 <?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("dynamic", $con);

$user_name = $_POST["user_name"];
$value = implode(',', $user_name); 
$user_email = $_POST["user_email"]; 
$valueone = implode(',', $user_email); 

$sql="INSERT INTO dynamicdata (user_name, user_email)
VALUES
('$value','$valueone')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

Since you are just starting out, let me gently point out that SQL tables shouldn't be like that. Please find a tutorial on database normalization and read that before writing any more code or trying to get this fixed. — e4c5
– e4c5, Commented Jan 5, 2017 at 10:49
Every time you use the mysql_ database extension in new code a Kitten is strangled somewhere in the world it is deprecated and has been for years and is gone for ever in PHP7. If you are just learning PHP, spend your energies learning the PDO or mysqli database extensions. Start here — RiggsFolly
– RiggsFolly, Commented Jan 5, 2017 at 10:51
Hi , Thanks for quick reply . I need this done urgently because there are thousands of code in our project . Am not in a position to change since we have meet the deadline .On the later stage we can go through database normalization and change the code . Is there any alternate solution for this . — Shabarish Shetty
– Shabarish Shetty, Commented Jan 5, 2017 at 10:54
You may also want to check your browsers debug console and fix the javascript error as well — RiggsFolly
– RiggsFolly, Commented Jan 5, 2017 at 10:54

Pranav MS · Accepted Answer · 2017-01-05 11:22:53Z

1

Just fetch the data from the table and explode both username and useremail to make array and just loop it and diplay the values.

Below pasted code may help you.

<?php
$ArrUserName=explode($username,','); //exploding the coma separated username to make array of user names
$ArrUserEmail=explode($username,',');//exploding the coma separated user email to make array of user email
echo '<table><tr><td>Name</td><td>EMAIL</td></tr>';
for($i=0;$i<count($ArrUserName);$i++){
    echo "<tr>";
        echo"<td>".$ArrUserName[$i]."</td>"; //display user name
        echo"<td>".$ArrUserEmail[$i]."</td>"; // diaplay user email
    echo"</tr>";        
}
?>

Please understand this nd try to implement in your code.

answered Jan 5, 2017 at 11:22

Pranav MS

2,3212 gold badges26 silver badges57 bronze badges

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

2 Comments

Shabarish Shetty Over a year ago

This code was very useful and it gave me the result exactly what i wanted. .

Pranav MS Over a year ago

If the answer is correct then please do up vote for the same. Then only then stack overflow newbie s can reffer this .

Ryan Hipkiss · Accepted Answer · 2017-01-05 11:23:44Z

1

Ideally, you would want the username and email stored in a new row for each user. This would make it a lot simpler for yourself.

However, try something like:

<?php 

$query   = mysql_query('SELECT * FROM dynamicdata LIMIT 1', $con);
$results = mysql_fetch_assoc($query);

$usernames = explode(',', $results['user_name']);
$emails    = explode(',', $results['user_email']);

//Now we should be able to loop over them.
for($row = 0; $row <= count($usernames); $row++) {
    echo $usernames[$row] . ' : ' . $emails[$row];
}

I haven't had chance to test this, but hopefully it works.

answered Jan 5, 2017 at 11:23

Ryan Hipkiss

6782 gold badges7 silver badges22 bronze badges

Collectives™ on Stack Overflow

PHP mysql - Display comma separated value from the database in tabular form

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related