RE: [PHP-DB] Re: [PHP] mysl_connect question
This is getting way off topic for the PHP list... What was the GRANT command you used to create this new user? When you issue the command the "[EMAIL PROTECTED]" part should match what you're getting in the error message. So if you granted permission for [EMAIL PROTECTED], then it's not going to work. It must be [EMAIL PROTECTED] or whatever your error message is saying. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 05, 2003 10:55 PM > To: Jim Lucas; [EMAIL PROTECTED] > Subject: [PHP-DB] Re: [PHP] mysl_connect question > > Thanks for you help! > > First I tried flush privileges and I have tried to reboot mysql. I am > running into a problem if I use user @localhost or @mysite.com. I have > tried setting up the user with both those domains inside both mysql.User > and > mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with > success. > > I can still connect on the command line but not using mysql connect, I get > the following error: > > Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in > 3rdpage.php on line 123 > > I'm at a loss... > > /T > > PS: sorry about the cross posting, it won't happen again... > > > on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: > > > did you reload mysql so it will have the new user? > > > > Jim > > - Original Message - > > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > > To: "php mailing list list" <[EMAIL PROTECTED]> > > Sent: Saturday, April 05, 2003 10:40 AM > > Subject: [PHP] mysl_connect question > > > > > >> When I use myssql to connect to a db with anything besides root I get > an > >> error that I cannot connect. I created a user that has access to one > >> databse called 'menu'. The user has SELECT, UPDATE, and DELETE > permissions > >> for that database. > >> > >> I can connect on the command line: mysql-u newuser -p. But no luck > using > >> mysql_connect(). > >> > >> Anyone have this problem? > >> > >> > >> .T > >> > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Updating and deleting
> Why won't this work?
Because you didn't tell us what the problem was.
---John Holmes...
>
> Edit Show List
>
> $db = mysql_connect("localhost", "root");
> mysql_select_db("websitedb",$db);
>
>
>
> if($sent) {
>
> $sql = "UPDATE bp set sent=$sent where fname=$fname AND
lname=$lname";
> mysql_query($sql);
> ?> Senthttp://twostep.antsmarching.org/bpedit.php3";>Back
>
> }else if($received) {
>
> $sql = "UPDATE bp set received=$received where fname=$fname AND
> lname=$lnam;";
> mysql_query($sql);
> ?> Received href="http://twostep.antsmarching.org/bpedit.php3";>Back
> } else if($delete) {
>
> $sql = "DELETE FROM bp WHERE lname=$lname AND fname=$fname";
> mysql_query($sql);
> ?> Delete href="http://twostep.antsmarching.org/bpedit.php3";>Back }
>
>
> $result = mysql_query("SELECT * FROM bp ORDER by showdate", $db);
>
> echo "\n";
>
> echo "DateName align=center>Address 1Address 2 align=center>City, State
> ZipReceivedSentEdit";
>
>
> while($myrow = mysql_fetch_row($result))
> {
> printf("%s%s %s%s%s%s, %s
> %s%s%s", $myrow[7], $myrow[1], $myrow[0],
> $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[8],
> $myrow[9]);
> printf("Received",
> $PHP_SELF, $myrow[0], $myrow[1]);
> printf("sent",
> $PHP_SELF, $myrow[0], $myrow[1]);
> printf(" href=\"%s?lname=%s&fname=%s&delete=yes\">Delete",
$PHP_SELF,
> $myrow[0], $myrow[1]);
> }
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: mysl_connect question
Did you Mysql>FLUSH PRIVILEGES; ? http://www.ephgroup.com Secure Hosting Accounts for everyone. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 April 2003 19:42 To: [EMAIL PROTECTED] Subject: mysl_connect question When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But no luck using mysql_connect(). Anyone have this problem? .T --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Updating and deleting
Why won't this work?
Edit Show List
Senthttp://twostep.antsmarching.org/bpedit.php3";>Back Receivedhttp://twostep.antsmarching.org/bpedit.php3";>Back Deletehttp://twostep.antsmarching.org/bpedit.php3";>Back \n";
echo "DateNameAddress
1Address 2City, State
ZipReceivedSentEdit";
while($myrow = mysql_fetch_row($result))
{
printf("%s%s %s%s%s%s, %s
%s%s%s", $myrow[7], $myrow[1], $myrow[0], $myrow[2], $myrow[3],
$myrow[4], $myrow[5], $myrow[6], $myrow[8], $myrow[9]);
printf("Received", $PHP_SELF,
$myrow[0], $myrow[1]);
printf("sent", $PHP_SELF,
$myrow[0], $myrow[1]);
printf("Delete",
$PHP_SELF, $myrow[0], $myrow[1]);
}
Re: [PHP-DB] Re: [PHP] mysl_connect question
The access denied message you are seeing is usually the result of either an incorrect password or username, but you don't give enough information to allow guessing beyond that. Are you certain your script is submitting the expected values? Doug On Sat, 05 Apr 2003 21:54:33 -0600, [EMAIL PROTECTED] wrote: >Thanks for you help! > >First I tried flush privileges and I have tried to reboot mysql. I am >running into a problem if I use user @localhost or @mysite.com. I have >tried setting up the user with both those domains inside both mysql.User and >mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with success. > >I can still connect on the command line but not using mysql connect, I get >the following error: > >Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in >3rdpage.php on line 123 > >I'm at a loss... > >/T > >PS: sorry about the cross posting, it won't happen again... > > >on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: > >> did you reload mysql so it will have the new user? >> >> Jim >> - Original Message - >> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >> To: "php mailing list list" <[EMAIL PROTECTED]> >> Sent: Saturday, April 05, 2003 10:40 AM >> Subject: [PHP] mysl_connect question >> >> >>> When I use myssql to connect to a db with anything besides root I get an >>> error that I cannot connect. I created a user that has access to one >>> databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions >>> for that database. >>> >>> I can connect on the command line: mysql-u newuser -p. But no luck using >>> mysql_connect(). >>> >>> Anyone have this problem? >>> >>> >>> .T >>> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] mysl_connect question
Thanks for you help! First I tried flush privileges and I have tried to reboot mysql. I am running into a problem if I use user @localhost or @mysite.com. I have tried setting up the user with both those domains inside both mysql.User and mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with success. I can still connect on the command line but not using mysql connect, I get the following error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in 3rdpage.php on line 123 I'm at a loss... /T PS: sorry about the cross posting, it won't happen again... on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: > did you reload mysql so it will have the new user? > > Jim > - Original Message - > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: "php mailing list list" <[EMAIL PROTECTED]> > Sent: Saturday, April 05, 2003 10:40 AM > Subject: [PHP] mysl_connect question > > >> When I use myssql to connect to a db with anything besides root I get an >> error that I cannot connect. I created a user that has access to one >> databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions >> for that database. >> >> I can connect on the command line: mysql-u newuser -p. But no luck using >> mysql_connect(). >> >> Anyone have this problem? >> >> >> .T >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] HELP HELP HELP SELECT not work
My psychic powers are a bit out of tune, but I think the problem is on line 35 of your code. [EMAIL PROTECTED] wrote: My PHP scripts don't execute the SELECT queries after execute the first. My web execute PHP scripts for work with MYSQL, all on Apache webserver. PHP version: 4.1.2 MySQL version: 3.22.32 The queries executed directly in MYSQL works. Where is the problem? These scripts run well for more times before this problem. Antonio Gabrielli -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Prefix question
Does anyone know of a prefix convention used for PHP? What I'm talking about is using a type of Hungarian notation for PHP variables. I know they use 'g', 'm', and 'r' for global, method and reference variables but for other variable types. I get confused once and a while, while I am coding and want to make things clearer than mud... Just a thought... Robin Kopetzky Black Mesa Computers/Internet Services
Re: [PHP-DB] Right-click
First, this should probably be sent to the PHP general mailing list, not the PHP-DB one. Does anyone know if there is a function in PHP that allows you to right-click on an item, and from there a drop down menu pops up and you can go to another screen, preserving that value that was clicked on? No. PHP is server-side and what you are describing would be client-side. You might be able to do something like that in JavaScript but I have no idea myself. If there is no function for right-clicking, then is there a way that when you are selecting something, not on a form, but in a tree, that you can get the value of what you clicked on into the PHP file? If you make any element on a Web page a url, and make the url something like page.php?clickedon=this, then the PHP page that the user goes to would have a $clickedon ($_GET['clickedon']) variable. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Right-click
Does anyone know if there is a function in PHP that allows you to right-click on an item, and from there a drop down menu pops up and you can go to another screen, preserving that value that was clicked on? If there is no function for right-clicking, then is there a way that when you are selecting something, not on a form, but in a tree, that you can get the value of what you clicked on into the PHP file? Thanks, Alexa
RE: [PHP-DB] mysl_connect question
> When I use myssql to connect to a db with anything besides root I get an > error that I cannot connect. I created a user that has access to one > databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions > for that database. > > I can connect on the command line: mysql-u newuser -p. But no luck using > mysql_connect(). You probably do not have the correct 'host' given for the user. What's the complete error message? It usually says something like "Access denied for [EMAIL PROTECTED] ..." Make sure the user you added matches the host given in the error message. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysl_connect question
First, please don't cross-post. The PHP-DB list is the proper one for this question. If you can connect via the mysql monitor but not with PHP, I expect the problem has to do with your host. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysl_connect question
When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But no luck using mysql_connect(). Anyone have this problem? .T -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle oci8
Hello, I'm sure this question has been asked, but i was wondering if anyone has successfully gotten oci8 working with php on windows? I've been trying for quite awhile with no success. thanks for any help, Paul _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] HELP HELP HELP SELECT not work
My PHP scripts don't execute the SELECT queries after execute the first. My web execute PHP scripts for work with MYSQL, all on Apache webserver. PHP version: 4.1.2 MySQL version: 3.22.32 The queries executed directly in MYSQL works. Where is the problem? These scripts run well for more times before this problem. Antonio Gabrielli -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
