List:General Discussion« Previous MessageNext Message »
From:Darryle Steplight Date:February 26 2009 6:34pm
Subject:Re: catch the error
View as plain text  
Hi PJ,
   $db_host = 'biggie';
$db_user = 'root';
$db_pass = 'gugus@#$';
$db_name = 'biblane';



Everyone here is trying to help you and that's cool, but EVERYONE on
this list may not be so nice. The above credentials is definitely the
type of information you want to keep private, unless you don't mind
people potentially accessing your database tables and doing whatever
they like with them.

I suggest doing something like
$db_host = 'localhost;
$db_user = 'foo';
$db_pass= ''bar;
$db_name =''xxxxxx;

if you are going to post it on the list.

On Thu, Feb 26, 2009 at 1:22 PM, PJ <af.gourmet@stripped> wrote:
> Ricardo Dias Marques wrote:
>> Hi PJ,
>>
>> On Thu, Feb 26, 2009 at 17:28, PJ <af.gourmet@stripped> wrote:
>>
>>
>>> What is wrond with this file? same identical insert works from console
>>> but not from this file :-(
>>>
>>> [snip]
>>>
>>> <?
>>> //include ("lib/db1.php");    // Connect to database
>>> mysql_connect('biggie', 'user', 'password', 'test');
>>> $sql1 = "INSERT INTO example (name, age) VALUES ('Joe Blow', '69')";
>>> $result1 = mysql_query($sql1,$db);
>>> if (!$result1) {
>>>  echo("<P>Error performing 1st query: " .
>>>       mysql_error() . "</P>");
>>>  exit();
>>> }
>>> ?>
>>>
>>
>> I haven't coded in PHP for a long time, but I think that your problem
>> is in this line:
>>
>> $result1 = mysql_query($sql1,$db);
>>
>> Up to that point, $db (that should point to a database link
>> identifier) is not defined. You probably want to assign the
>> "mysql_connect" result to that $db variable.
>>
>>
>> So, I think that you will solve your problem by changing your
>> "mysql_connect" line FROM the current form:
>>
>> mysql_connect('biggie', 'user', 'password', 'test');
>>
>> .. TO this one:
>>
>> $db = mysql_connect('biggie', 'user', 'password', 'test');
>>
>>
>> Am I right?
> Partly. I had an error in the location of the include. Ashley corrected
> the rest but it only works with the include. Not as whown below
> <?
> //include ("../lib/db1.php");    // Connect to database
>
> $db_host = 'biggie';
> $db_user = 'root';
> $db_pass = 'gugus@#$';
> $db_name = 'biblane';
>
> $db_connect = mysql_connect($db_host, $db_user, $db_pass);
> $db_select = mysql_select_db($db_name, $db_connect);
>
> $sql1 = "INSERT INTO test (name, age) VALUES ('Arnie Shwartz', '75')";
> $result1 = mysql_query($sql1,$db);
> if (!$result1) {
>  echo("<P>Error performing 1st query: " .
>       mysql_error() . "</P>");
>  exit();
> }
> ?>
>
> --
>
> Phil Jourdan --- pj@stripped
>   http://www.ptahhotep.com
>   http://www.chiccantine.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
catch the errorPJ26 Feb
  • Re: catch the errorDarryle Steplight26 Feb
    • Re: catch the errorPJ26 Feb
      • Re: catch the errorJim Lyons26 Feb
        • Re: catch the errorPJ26 Feb
      • Re: catch the errorDarryle Steplight26 Feb
        • Re: catch the errorPJ26 Feb
  • Re: catch the errorRicardo Dias Marques26 Feb
    • Re: catch the errorPJ26 Feb
      • Re: catch the errorDarryle Steplight26 Feb
  • RE: catch the errorJerry Schwartz26 Feb
    • Re: catch the errorPJ26 Feb
  • Re: catch the error [OFF TOPIC]Claudio Nanni26 Feb