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@xxxxxxxxxxxx> wrote:
> > Ricardo Dias Marques wrote:
> >> Hi PJ,
> >>
> >> On Thu, Feb 26, 2009 at 17:28, PJ <af.gourmet@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> > 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=dsteplight@xxxxxxxxx
> >
> >
>
I agree. I wouldn't trust me at all! ;)
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
