[PHP] Need recommendation: good user management system (PHP/MySQL)
I'm just starting to learn PHP and it's going to take a while before I can create a really good script to password protect a section of my site, with a good admin control center to manage my user's accounts. Therefore I'm asking for recommendations on a good retail script that can handle this for me until I'm skilled enough to create my own. I'm a little desperate since I'm using a poorly written CGI script at the moment. I'm looking for a customizable PHP/MySQL script to password protect an area of my site and add/edit user's accounts. You know the usual member management script. Thanks in advance! // Andreas
[PHP] Code check please
I've tried to get this working for over an hour
now, and it still won't. I don't even get an error
message to help me find the problem so I was
hoping that someone could check my code for me.
I'm fooling around with a basic form that is
supposed to send one's name, surname and e-mail
address to receive.php. receive.php is then
supposed to take the information and add it to a
table called tabell in a database called
databas, but it doesn't work. I think there
might be something wrong with my MySQL query.
- - - - - - - - - - - FORM - - - - - - - - - - - -
- -
form action=receive.php method=post
PFouml;rnamn:br
input type=text name=fornamn
size=25/p
pEfternamn:br
input type=text name=efternamn
size=25/p
pE-mailadress:br
input type=text name=email
size=25/p
input type=submit name=submit
value=Log in
/form
- - - - - - - - - - - - - - - - - - - - - - - - -
- - -
- - - - - - - - - - - RECEIVE.PHP - - - - - - - -
- - -
?php
// connection to MySQL
$connection = mysql_connect(localhost,
username, password);
if (!$connection) {
echo (PUnable to connect to the database
server at this time./P );
exit();
}
//select database
if (! @mysql_select_db(databas) ) {
echo (PUnable to locate the database at
this time./P);
exit();
}
// MySQL query
$sql = INSERT INTO tabell SET .
fornamn ='$fornamn', .
efternamn='$efternamn', .
email='$email';;
?
- - - - - - - - - - - - - - - - - - - - - - - - -
- - -
Thanks in advance!
// Andreas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Code check please
I'm sorry guys, neither of the snippets work. I must have screwed something else up
too. Is there any way I can provoke an error message from your code examples below?
If anyone manages to find out what's wrong, please tell me. I'm not giving up until
I smash this bug :-)
// Andreas
Rich Cavanaugh wrote:
try:
$sql = INSERT INTO tabell (fornamn, efternamn, email) values ('{$fornamn}',
'{$efternamn}', '{$email}');
Sebastian Wenleder wrote:
I'd use this SQL-query:
$sql = INSERT INTO tabell \
(fornamn,efternamn,email) \
VALUES(.$fornamn., \
.$efternamn., .$email.);
--
Andreas Skarin
Svenska Dream Theater-Sällskapet
http://www.sdts.nu - mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
