|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
March 4th, 2003, 12:16 PM
|
|||
|
|||
|
Php forum connection
i created a simple forum for a web page whit a ACCESS database
it works great on my machine but when i put it on the net it dosent connect whit my db. can some1 tell me the proper way to connect to my database its made whit Access and is called forum forum.php <? // This is the DSN we have create for our database $connect = odbc_connect("forum", "root", ""); ?> <HTML> <BODY> <div align="center"><BR> <BR> <A HREF='node.php?node=0'>Écrire un nouveau message</A> <? shownode(0); // display all the main threads // This function is a recursive function which shall display all the branches // and sub branches of the threads function shownode($nodecode) { global $connect; // using the global variable for connection // Get a list of all the sub nodes which specific parentcode $noderesult = odbc_exec($connect,"select * from forum where parentcode = $nodecode"); echo "<UL type='disc'>"; while(odbc_fetch_row($noderesult)) // get all the rows { $code = odbc_result($noderesult,"code"); $title = odbc_result($noderesult,"title"); $uname = odbc_result($noderesult,"uname"); $email = odbc_result($noderesult,"email"); echo "<LI>"; echo "<A HREF='node.php?node=$code'> $title </A>"; echo "-- de ($uname) $email<BR>"; shownode($code); } echo "</UL>"; } ?> </div> </BODY> </HTML> node.php <? $connect = odbc_connect("forum", "root", ""); if(isset($submit)) // check if submitted button is clicked { // insert the record in the database $resultupdate=odbc_exec($connect,"insert into forum (parentcode,title,description,uname,email) VALUES ($node,'$title','$description','$postname','$email ')"); header("location:forum.php"); // open forum.php file to display the thread exit; } ?> <? if ( $node != 0 ) { // Displaying the details of the thread echo "<HR>"; $noderesult = odbc_exec($connect,"select * from forum where code = $node"); $noderow=odbc_fetch_row($noderesult); $title = odbc_result($noderesult,"title"); $description = odbc_result($noderesult,"description"); $uname = odbc_result($noderesult,"uname"); $email = odbc_result($noderesult,"email"); echo "$title by ($uname) $email<BR>"; echo "$description <BR><HR>"; } ?> <!-- Form to enter the message --> <FORM method='post'"> <div align="center"> <p>Nom : <INPUT TYPE=TEXT NAME=postname> E-Mail : <INPUT TYPE=TEXT NAME=email> <BR> Titre : <INPUT TYPE=TEXT NAME=title VALUE = '' size=50> <BR> Description : <BR> <TEXTAREA name=description rows=10 cols=45></TEXTAREA> </p> <p> <!-- we need a hidden field to store the node --> <INPUT TYPE=hidden NAME=node value='<? echo $node;?>'> <BR> <INPUT type=submit name=submit value='Post Message'> </p> </div> </FORM>
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Php forum connection |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
