Page 1 of 1

Empty value from mysql into php form

Posted: Tue Oct 20, 2015 8:13 am
by publicGenome
Hi There,
I'm a noob in web development, thus kindly pardon my naive query.
Work flow of my page:
pull data/row from mysql. Data has a certain column which may or many not be blank. Column name: reverse primer. I'm pulling information, and trying to display that in a html form in PHP page.

Code: Select all

		foreach ($result as $row){
			echo "<tr>";	
			
			echo "<td>"."<input name=study disabled value=".$row['study']." </td>";
			echo "<td>"."<input name=forward_primer disabled value=".$row['forward_primer']." </td>";
			echo "<td>"."<input name=reverse_primer disabled value=".$row['reverse_primer']."  </td>";
			echo "<td>"."<input name=seq_platform disabled value=".$row['seq_platform']." </td>";
			
			echo "</tr>";
		}
Here at the td with reverse primer row, I get </td > shown in the attached screen shot. How do I disable to stop it from doing? Even if I send to a function, check it, I still will have null, unless I decide it to show NA or otherwise.

Best,
pG

Re: Empty value from mysql into php form

Posted: Tue Oct 20, 2015 10:59 am
by publicGenome
Hi There,
An update:

I was able to fix this using single quotes around reverse_primer variable:

echo "<td>"."<input name=reverse_primer disabled value='".$row['reverse_primer']."' /></td>";