First off, this is a PHP development issue, not necessarily a mysql
issue. Nonetheless, I have included some comments.
On Mon, 2003-06-16 at 07:33, sgannon60 wrote:
I am using PHP, Mysql on IIS5.
Process
1 - submit a unique user name, password
2- check against database and if successful enter details in database which
creates a primary key which is the constant between the client details table
and the projects
3 - when a successful login if the first time a blank client details form,
or if an existing client an update form with list of projects.
I do not understand how to get the primary key generated after the initial
submission to be available on each page to tie all the elements to the right
client.
Assuming the primary key is an auto_increment field, you can run:
SELECT LAST_INSERT_ID();
In your php code, to retrieve this you can do the following:
?
mysql_pconnect('h','u','p');
mysql_select_db('d');
mysql_query(INSERT INTO foo(bar) VALUES('abc'));
print Insert ID: . mysql_insert_id() . br /;
?
I am thinking if I send the unique username as a form variable or http
variable I can use that to filter the password table to finfd the unique ID
Mind you if I do that why don't I just use the username as the unique
Element
Having the username be unique is a plus, but remember too that a
character string takes more time to SELECT than say an unsigned integer.
When you have tables that require information about the user (say the
user that created record X), it is slightly more efficient to use an
unsigned int as the primary key rather than the varchar username.
The problem now is that something that my book is telling m,e is dead simple
aint so simple for me.
When I try to read the form variable I get
Notice: Undefined index: username in c:\inetpub\wwwroot\ias_php\success.php
on line 9
I have tried altering this parameter to 1 for an IIS server with no joy.
cgi.rfc2616_headers = 0
This isn't what you're looking for at all.
This is the page in question.
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
pseuceees
?php $HTTP_POST_VARS['username']; ?
The undefined index you are getting is because
$HTTP_POST_VARS['username'] is not set, try running something like this:
?php
if (isset($HTTP_POST_VARS['username']))
{
print HTTP_POST_VARSbr /;
}
elseif (isset($_POST['username']))
{
print POSTbr /;
}
else
{
phpinfo();
}
?
Here, I use the 'isset()' routine to verify that the variable is set
(which will get rid of that 'undefined index' error message you are
seeing). Additionally, if $HTTP_POST_VARS and $_POST variables aren't
set, it dumps a phpinfo(); My guess is that you aren't posting to the
page, so it's not being registered.
/p
pnbsp; /p
/body
/html
Any pointers or answers will be much appreciated
Hopefully this information has helped a bit, however please note that
the issues noted above are not mysql issues but php issues. This email
was sent to the mysql lists.
Steve
Thanks,
Ryan Yagatich
--
,_,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http://www.pantek.com/security(440) 519-1802 \
/ Are your networks secure? Are you certain? /
\___A9062F5C3EAE81D54A28A8C1289943D9EE43015BD8BC03F1___\
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
