List:General Discussion« Previous MessageNext Message »
From:PJ Date:February 26 2009 6:56pm
Subject:Re: [PHP] Re: catch the error
View as plain text  
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote:
>   
>> 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
>>>
>>>
>>>       
> I agree. I wouldn't trust me at all! ;)
>
>
> Ash
> www.ashleysheridan.co.uk
>
>
>   
Yeah.... very stupid of me...but I found the error: see if you can catch it:
<?
//include ("../lib/db1.php");    // Connect to database

$db_host = 'xxx';
$db_user = 'xxx;
$db_pass = 'xxx';
$db_name = 'xxx';


$db = mysql_connect($db_host, $db_user, $db_pass);   
mysql_select_db($db_name,$db);

$sql1 = "INSERT INTO test (name, age) VALUES ('Arnie Shwartz', '75')";
$result1 = mysql_query($sql1,$db);
if (!$result1) {
  echo("<P>Error performing 3st query: " .
       mysql_error() . "</P>");
 
}
echo $sql1;
echo "<br />";
echo $db_select;
exit();
?>

-- 

Phil Jourdan --- pj@stripped
   http://www.ptahhotep.com
   http://www.chiccantine.com

Thread
Re: [PHP] Re: catch the errorDarryle Steplight26 Feb
Re: [PHP] Re: catch the errorPJ26 Feb
Re: [PHP] Re: catch the errorPJ26 Feb
Re: [PHP] Re: catch the errorPJ26 Feb
Re: [PHP] Re: catch the errorPJ27 Feb