Hi Marvin, what exactly happens when you try to submit? what's the exact error message? is your required file loaded successfully? perhaps you can provide some more info on the nature of your problem.
Gabby Dizon Web Developer INQ7 Interactive, Inc. http://www.inq7.net http://you.inq7.net ----- Original Message ----- From: "Marvin T. Pascual" <[EMAIL PROTECTED]> To: "Philippine Linux Users' Group" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 7:49 AM Subject: [plug] PHP+Apache+PostgreSQL Problem > Hello PLUGgers, > > I need your help. > > I have my SURVEY FORM in http://pascual.homelinux.org which is written > mostly in HTML and a little on PHP 4.2.1-8mdk. I'm running Apache > 1.3.26-5mdk as my web server. My PHP and Apache are installed in my > gateway box which has an internal IP address of 192.168.0.1. I have > PostgreSQL 7.2.1-8mdk installed in my 192.168.0.2 box. > > My problem is, I don't know why I can't "SUBMIT" from my SURVEY FORM to > my PostgreSQL server. I already checked my connection by accessing > PostgreSQL remotely from my 192.168.0.1 box and I was able to connect. > > Did I miss something? > > Below is the snippet of my submit.php > > - - - < s n i p > - - - > > <html><head><title>Processing Form...</title></head> > <style> > {text-decoration:none; color:#00ccff} > </style> > <body> > <?php > > // Connect to the database > require_once('DB.php'); > $db = DB::pg_connect("pgsql:[EMAIL PROTECTED]/survey"); > if (DB::iserror($db)) { > die($db->getMessage()); > } > > // Die on GET requests (For security) > if ($_SERVER['REQUEST_METHOD'] == 'GET') > { > die ("Works with HTTP-POST Method only."); > } > > // Get the form values > $lastname = $_POST['lastname']; > $firstname = $_POST['firstname']; > $mi = $_POST['mi']; > $age = $_POST['age']; > $gender = $_POST['gender']; > $status = $_POST['status']; > $industry = $_POST['industry']; > $position = $_POST['position']; > $occupation = $_POST['occupation']; > $tctco = $_POST['tctco']; > $cstco = $_POST['cstct']; > $tceoa = $_POST['tceoa']; > $cseoa = $_POST['cseoa']; > $tcds = $_POST['tcds']; > $csds = $_POST['csds']; > > // Issue the SQL query to insert the values > $sql = "INSERT INTO results values ("; > $sql .= "'$lastname','$firstname','$mi','$age','$gender',"; > $sql .= "'$status','$industry','$position','$occupation',"; > $sql .= "'$tctco','$cstco','$tceoa','$cseoa','$tcds','$csds')"; > $q = $db->query($sql); > > ?> > > // Display a confirmation page > > <h1>Processing Form</h1> > The form data you submitted has been added to our database. Thank you > very much. > <br><a href="index.php">Return to index</a> > </body> > </html> > > - - - < s n i p > - - - > > Below are the queries from my PostgreSQL: > > survey=# \z > Access privileges for database "survey" > Table | Access privileges > ---------+---------------------------------------------- > results | {=,postgres=arwdRxt,bintut=a,apache=arwdRxt} > (1 row) > > survey=# \d results > Table "results" > Column | Type | Modifiers > ------------+------+----------- > lastname | text | > firstname | text | > mi | text | > age | text | not null > gender | text | not null > status | text | not null > industry | text | not null > position | text | not null > occupation | text | not null > tctco | text | not null > cstco | text | not null > tceoa | text | not null > cseoa | text | not null > tcds | text | not null > csds | text | not null > > - - - < s n i p > - - - > > > Thank you very much... > > Marvin Pascual > > > _ > Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED] > _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
