check script, please

tmann

Hi, I'm working on a script that will take a user's name and email address, generate a random password, store the name/e themail/password in a database, and finally email the password to the user. Got all that?! Anyway, when I fill the data into the form and hit submit, I get sent to a blank page (well, actually when I view the source I see html, head, doctype, body tags, but nothing else. Here's a link to text files containing my code:
http://www.unc.edu/~tmann/php

The header and footer include files shouldn't be the problem since they display properly on the first page (user_register.php). In case it helps, here's the link to the actual php files:
http://web9.isis.unc.edu/studgov/executive/dev/user_register.php

Any help at all would be very much appreciated!!

Thanks!
Tommy
tmann@email.unc.edu

jerdo

Does the data make it to your database and the email get sent? It appears from the code you've supplied that you only out put text if there is an error in the submitted data.

kutte

hi tmann, when I take a look into your user_register.txt it seems to me that you are testing your mail functon on a window system.

as I know windows does'nt have any sendmail.

to do this you have to install i.e. SendmailClone v1.03 on your windows system.

You'll find it here SendmailClone v1.03

hope I could help and was not wrong...

tmann

How did you know I was on a Windows system? My local machine is windows...but I thought the server I'm uploading to (http://web9.isis.unc.edu/studgov/executive/dev/user_register.php) is a Solaris box.

Thanks,

Tommy

tmann

Originally posted by jerdo
Does the data make it to your database and the email get sent? It appears from the code you've supplied that you only out put text if there is an error in the submitted data.

Jerdo,

No, the data doesn't make it into the database. I should be outputting a message regardless of what happens -- if the user doesn't fill in all the fields, if there is an error connecting to the DB, or if all is successful. Here's the code that outputs a message if there is success:

if (!mysql_query($sql,$connection)) {
echo "Error, cannot add record. Hit the back button and try again.<br>";
exit;
} else {

insert ok

echo "Table updated. The record of has been added.";
}

Does that work? Can you see anything else going on here?

Thanks for the help!
Tommy

jordy

first of all you can check if the mail sended is in the local mail queing spool.. this can be done with the simple commando:

<? system("sendmail -bp"); //sendmail server ?>
<? system("mailq"); //postfix server ?>

secondly:
make sure the db_connect.php file contains no errors.. as a example i attached one of my connection libs to this message you are free to try that one..

last:
try and error. if it still won't work cu at phpbuilder.com 🙂

tmann

Originally posted by jordy
first of all you can check if the mail sended is in the local mail queing spool.. this can be done with the simple commando:

<? system("sendmail -bp"); //sendmail server ?>
<? system("mailq"); //postfix server ?>

secondly:
make sure the db_connect.php file contains no errors.. as a example i attached one of my connection libs to this message you are free to try that one..

last:
try and error. if it still won't work cu at phpbuilder.com 🙂

Thanks -- I placed your file on my machine, changed the mysql server info, but when I loaded the page it was blank. Just to see what would happen, I used the wrong mysql password and the page still loaded blank! What's going on here? Aren't there supposed to be some errors? Also, I'm using the RW account that my mysql admin set up for me. Should I be using the RO account?

Thanks!
Tommy

jordy

you can check if errormessaging is turned on on the php parser. check php.ini for:

error_reporting = E_ALL & ~E_NOTICE

if this variable has another value that might suppress error messages try the one above..

tmann

Originally posted by jordy
you can check if errormessaging is turned on on the php parser. check php.ini for:

error_reporting = E_ALL & ~E_NOTICE

if this variable has another value that might suppress error messages try the one above..

The php info file says:
error_reportin | 2047 | 2047 |

So I guess that's why I'm seeing errors? There's an error log that I can look at, maybe that will help. Is there anyway to turn error reporting on for my site (I don't have access to the php.ini file)?

Thanks again!
Tommy

tmann

Okay, I checked the error file...it says there's a parse error on line 39...here's the code

if (!mysql_query($sql,$connection)) {
echo "Error, cannot add record. Hit the back button and try again";
exit;
} else {

insert ok

echo "Table updated. The record of has been added.";
}

The first echo statement is line 39. Could it be that mysql_query isn't valid in my php configuration?

Thanks,
Tommy

jordy

what you can do is a phpinfo() function.. the php must be compiled --with-mysql
example my phpinfo:

http://www.querner.com/static/phpinfo.php

notice:

Configure Command './configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-ftp'

tmann

Well, mine looks similar. Here it is:

'./configure' '--with-mysql=/usr/mysql' '--with-apxs=/opt/local/apache-standard/bin/apxs'

Here's the link
http://web9.isis.unc.edu/php/phpinfo.php

-Tommy

jordy

okay practical example:

functions_db.php:
<?php
/****************************************************************************
Description: General MySQL database connection
Written by: DJ Querner (jordy@querner.com)
Date: februari 2001
For: Wegener eMedia (www.wegeneremedia.nl)
****************************************************************************/

$dbhost = 'mysql.server.tld';
$dbusername = 'myuser';
$dbuserpassword = 'passw0rd';
$default_dbname = 'mydb';

/****************************************************************************
Flush the error messages
****************************************************************************/
$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';

/****************************************************************************
This function connects the script to the database
Syntax:
db_connect();
****************************************************************************/
function db_connect($dbname='') {
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
if(!$link_id) {
$error_message("Connection failed to the host $dbhost.");
return 0;
}
else if(empty($dbname) && !mysql_select_db($default_dbname)) {
html_error(mysql_errno()." - ".mysql_error());
return 0;
}
else if(!empty($dbname) && !mysql_select_db($dbname)) {
html_error(mysql_errno()." - ".mysql_error());
return 0;
}
else return $link_id;
}

/****************************************************************************
This function performs a query on the mysql server and returns back the
results. error messages included.
Syntax:
QueryDb("SQL QUERY");
****************************************************************************/
function QueryDb($query)
{
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
if (!$link = @mysql_connect($dbhost, $dbusername, $dbuserpassword)){
$result = 0;
html_error("Error met het verbinden naar $dbhost!");
}
else {
if (!@mysql_select_db($default_dbname, $link)) {
$result = 0;
html_error("Error. kan $dbname niet vinden!");
}
else {
if (!$result = @($query, $link)) {
$result = 0;
html_error("Kan query $query niet uitvoeren");
}
}
}
return $result;
}

function html_error($error_message) {
global $error_status;
if ($error_status != 1) {
echo "<BR><BR>\n<TABLE CELLPADDING=3 CELLSPACING=1 BORDER=0 WIDTH=70%>\n";
echo "<TR><TD BGCOLOR='#BDC7DE' ALIGN=center><b>$error_message<b></TD></TR>\n";
echo "<TR><TD BGCOLOR='#BDC7DE' ALIGN=left><A HREF='javascript:history.go(-1)'> <-- Terug </A></TD>\n</TR>\n";
echo "</TABLE>\n";
$error_status = 1;
}
}

myfile.php:
<?
include("functions_db.php");

// with the functions_db.php
$rows = QueryDb($sql);
if (!$rows)) {
echo "Error, cannot add record. Hit the back button and try again";
exit;
} else {

insert ok

echo "Table updated. The record of has been added.";
}

//your example

$row = mysql_query($sql,$connection);
if (!$row) {
echo "Error, cannot add record. Hit the back button and try again";
exit;
} else {

insert ok

echo "Table updated. The record of has been added.";
}