php button

spoilchile

how can i create a button in a php page that can call a mysql query?

Weedpacket

PHP doesn't have buttons. You're thinking of HTML. Make the button the submit button of a form that submits to the PHP script that does the query.

Ashley_Sheridan

I've always found the simplest way to connect to the database and run queries is in two parts:

<?php
$dbhost = 'localhost';
$dbname = 'my_database';
$dbuser = 'root';
$dbpasswd = '';

// access MySQL
$dbc = mysql_connect ($dbhost, $dbuser, $dbpasswd);

// access the database
mysql_select_db ($dbname);
?>

Stick that bit in a separate file (connect.php) which you include in every page with an

include "connect.php";

statement. The next bit is for running any query:

$query = "SELECT * FROM `tablename` WHERE `some_column`=10";
$result = mysql_query($query);

Then after that you can grab the data out of the $result resource however you like.

spoilchile

I have created a registration form and when the "Submit" button is pressed it displays the fields in a php view page. If the info is incorrect the user clicks a "back" button to edit the incorrect fields. If the info is correct the user clicks "Continue". I would like the data to be inserted into the MySQL table only when the "Continue" button is pressed. Any ideas on how to do this?

Ashley_Sheridan

I think you have the wrong idea about what PHP is. The buttons are all in HTML, and I presume are taking you to different pages. PHP is all server side, so doesn't have events from buttons , etc. You need to put the PHP code on the pages which are being called, you can't attach it to buttons.