db crash course

[elkidogz]

ok, basically what i have is a phpNuke site that's up and running beautifully and what i want to do is add a custom made module, I have done an exercise for a basic html form to send it's data to a file on the server, that was cake. Now, i think i'm ready to try something a little more ambitious. I'd like to try to get that same html document to populate some fields in a table that i've created on the site.

what i'm wanting to know is if there is a sort of step by step method for getting this up.

i assume i'll need some connectivity items

db name
db location
db user
db pass

and of course a table and fields to populate, but is there any simple forms here that i could take a look at (read: copy) and tweak some to get it to work on mine? 😕

[cgraz]

a database table or an html table?

I've never worked with PHP-Nuke, but it might be easier to try getting this to work as a stand-alone (you can use the databases, etc from PHP-nuke, just create a script that runs on it's own on your server).

If I understand your question, you want to have the values submitted by a user via form populate an html table? If so, here's how:

1. You'll need to create the html form as usual, and set the form tag like this:

<form method="post" action="process.php"> where process.php is the php script that will handle the form values. method can be post or get, and you'd access the submitted variables in php via $POST and $GET respectively.

So if you have three fields: name, email, and phone, in process.php, you would just go like this:

<table class="form-results">
	<tr>
		<td>Name: <?php print $_POST['name']; ?></td>
	</tr>
	<tr>
		<td>Email: <?php print $_POST['email']; ?></td>
	</tr>
	<tr>
		<td>Phone: <?php print $_POST['phone']; ?></td>
	</tr>
</table>

You could add form validation, check for empty fields, etc, but this should get you going.

Hopefully I answered your question. Let me know if I misunderstood.

[Houdini]

If you are running PHP-Nuke you already have a database and all its tables are prefixed nuke_something. Your PHP-Nuke already connects to this database. all that information is in your config.php file which by default is in your ROOT directory (where you uploaded all the files and folders to your server. so all you need to do is create a table with the data of your choosing. You can call the table anything you want likemytable or mydata (just don't use spaces in the tablename). it might help if you posted the form that you now have and maybe other could offer suggestion on a table for the data you are gathering from the form.

If you do post code in these forums please use the BB Codes provided in these to see how to do that just click the link in my signature.

[elkidogz]

well what i am wanting is something that just updates a database with values, and another page that i can use to display those values.

so index.php would be the form

takes in say name and email

	<form id="application" action="updatedatabase.php" method="post">

	First name:
	<input type="text" name="fname" value="FirstName" />
	Last name:
	<input type="text" name="lname" value="LastName" />
	<input type="submit" value="Submit your application" />
</form>
 

then updatedatabase.php is where it does the inserts to a given table. the user would then be piped to a thanks page or something like that...

what i'm wondering is of course what's all needed to establish a connection say even if i didn't have a phpNuke site running, i know i can use the that database, I and I would create it's own table so that it is a "standalone" item...

then output.php is the page that would display those values within that table like a dump of the values. maybe have a few sort values on it.