MySQL Database showing on a page.

[jad9321]

Hello,
Is their anyway to make MySQL Database results show up in a web browser? As in the MySQL database tabel results will be shown on any page I want it to? The only option I want is for each seperate result to be deleted with a simple delete button. Anyone know of a script that can do this?

Thanks in advance,
Joe

[djr33]

Clearly, you want this secure... so don't code it yourself.

The point of mysql is to use php (and other languages) to get the data then display, yes, as html.


however, in this case, you'd want to use a real manager for it, so it's secure, can do a bunch, etc.

I'd recomment myphpadmin, if you don't already have that. If you do, get used to it... it's a good way to navigate, once you get used to the controls.

[jad9321]

Err... Dosen't need to be secure... I'm going to password protect it so its fine. And if its still not secure after the password than its not that big if a deal... Dosent matter to me if people can see it. I just want it to show on a page.

[Twey]

<?php
$conn = mysql_connect('dbserver', 'dbusername', 'dbpassword');
mysql_select_db('databasename');
$tablename = 'mytable';
if(isset($_GET['delete']))
  if(!is_numeric($_GET['delete'])) die();
  else mysql_query('delete from `' . $tablename . '` where id=' . $_GET['delete'] . ';');

$rs = mysql_query('select * from `' . $tablename . '`;');
$row = mysql_fetch_array($rs);
$cols = array();
foreach($row as $k => $v)
  array_push($cols, $k);
array_push($cols, 'del');
echo('<table><tr>');
for($i = 0; $i < count($cols); ++$i)
  echo('<th>' . $cols[$i] . '</th>');
echo('</tr>');
do {
  $row['del'] = '<form action="?delete=' . $row['id'] . '" method="get"><input type="submit" value="Delete"></form>';
  echo('<tr>');
  for($i = 0; $i < count($cols); ++$i) {
?>
<td><?php echo($row[$i]); ?></td>
<?php
  }
  echo('</tr>');
} while($row = mysql_fetch_array($rs));
echo('</table>');
?>

Untested.

[jad9321]

Ok do I need to change anything accept for the db info????

[Twey]

No, so long as you have a unique numerical column called "id".

[jad9321]

And how do you get that???

[jad9321]

?___?

[Twey]

Uh... you... add it to your table.

[jad9321]

Huhhh? Can you tell me how?