[Xerte] Re: database.php

[Dave Burnett]

Yes, but this is where it is now halting:

    foreach($params as &$value) {        if(isset($value)) {            if(get_magic_quotes_gpc()) {                $value = stripslashes($value);            }            $value = "'" . mysql_real_escape_string($value) . "'";        }        else {            $value = 'NULL';        }    }

 Can I take that block out without screwing any pass through value? 




> Date: Sun, 29 Apr 2012 15:35:07 +0100
> From: patrick.lockley at googlemail.com
> To: xerte at lists.nottingham.ac.uk
> Subject: [Xerte] Re: database.php
> 
> did you put the error reporting line in?
> 
> On Sun, Apr 29, 2012 at 3:32 PM, Dave Burnett <d_b_burnett at hotmail.com> wrote:
> >
> > database_library itself fails (no echo from line 1) if I include this
> > function:
> >
> > function db_query($sql, $params = array()) {
> >
> > If I take it out, the page returns various echos, including the call
> > to db_query_one()
> >
> > If I put db_query function back in, the page blows up.
> >
> >
> >
> >
> >> Date: Sun, 29 Apr 2012 15:15:29 +0100
> >> From: patrick.lockley at googlemail.com
> >> To: xerte at lists.nottingham.ac.uk
> >> Subject: [Xerte] Re: database.php
> >>
> >> sorry, being blind
> >>
> >> i'd look in database_library for the actual mysql_query line, and add
> >> it under that
> >>
> >> On Sun, Apr 29, 2012 at 3:11 PM, Dave Burnett <d_b_burnett at hotmail.com>
> >> wrote:
> >> > ??
> >> >
> >> > Isn't that where I have it? Following the db_query?
> >> >
> >> >
> >> >
> >> >> Date: Sun, 29 Apr 2012 15:08:22 +0100
> >> >
> >> >> From: patrick.lockley at googlemail.com
> >> >> To: xerte at lists.nottingham.ac.uk
> >> >> Subject: [Xerte] Re: database.php
> >> >>
> >> >> ok, so put the mysql_error in
> >> >>
> >> >> echo ("five config page");   //get this far
> >> >> $row = db_query_one("SELECT * FROM
> >> >> {$xerte_toolkits_site->database_table_prefix}sitedetails");
> >> >> echo mysql_error() . " <---- ERROR <br />";
> >> >>
> >> >> On Sun, Apr 29, 2012 at 3:04 PM, Dave Burnett <d_b_burnett at hotmail.com>
> >> >> wrote:
> >> >> > in config
> >> >> >
> >> >> > echo ("five config page");   //get this far
> >> >> >     $row = db_query_one("SELECT * FROM
> >> >> > {$xerte_toolkits_site->database_table_prefix}sitedetails");
> >> >> > echo mysql_error();  //nope
> >> >> > echo ("six config page");  //nope
> >> >> >
> >> >> >
> >> >> >
> >> >> >> Date: Sun, 29 Apr 2012 14:30:14 +0100
> >> >> >> From: patrick.lockley at googlemail.com
> >> >> >> To: xerte at lists.nottingham.ac.uk
> >> >> >> Subject: [Xerte] Re: database.php
> >> >> >>
> >> >> >> You don't have to close php tags at the end
> >> >> >>
> >> >> >> put the mysql_error into config.php after the mysql_query or
> >> >> >> db_query
> >> >> >> statement?
> >> >> >>
> >> >> >> On Sun, Apr 29, 2012 at 1:30 PM, Dave Burnett
> >> >> >> <d_b_burnett at hotmail.com>
> >> >> >> wrote:
> >> >> >> > Nothing at the bottom.
> >> >> >> >
> >> >> >> > Here at the top I get dave, but no dave 1
> >> >> >> > So, issue in config
> >> >> >> >
> >> >> >> > config has opening <?php but no close. Issue?
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > <?php
> >> >> >> > echo ("dave");
> >> >> >> > // This file could be used instead of index.php to perform
> >> >> >> > authentication.
> >> >> >> > // The list of usernames/passwords are hard coded below.  (search
> >> >> >> > for
> >> >> >> > 'sarah')
> >> >> >> >
> >> >> >> > require("config.php");
> >> >> >> > echo ("dave1");
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > ________________________________
> >> >> >> > From: patrick.lockley at googlemail.com
> >> >> >> > Date: Sun, 29 Apr 2012 12:30:11 +0100
> >> >> >> >
> >> >> >> > To: xerte at lists.nottingham.ac.uk
> >> >> >> > Subject: [Xerte] Re: database.php
> >> >> >> >
> >> >> >> > Ok.
> >> >> >> >
> >> >> >> > At the end of switch put echo mysql_error();
> >> >> >> >
> >> >> >> > On 29 Apr 2012, at 12:25, Dave Burnett <d_b_burnett at hotmail.com>
> >> >> >> > wrote:
> >> >> >> >
> >> >> >> >
> >> >> >> > I've always used renamed switch
> >> >> >> >
> >> >> >> >
> >> >> >> > ________________________________
> >> >> >> > From: patrick.lockley at googlemail.com
> >> >> >> > Date: Sun, 29 Apr 2012 10:31:48 +0100
> >> >> >> > To: xerte at lists.nottingham.ac.uk
> >> >> >> > Subject: [Xerte] Re: database.php
> >> >> >> >
> >> >> >> > Do you have ldap installed?
> >> >> >> >
> >> >> >> > On 29 Apr 2012, at 02:40, Dave Burnett <d_b_burnett at hotmail.com>
> >> >> >> > wrote:
> >> >> >> >
> >> >> >> >
> >> >> >> > OK. New install, same result.
> >> >> >> >
> >> >> >> > index.php = blank page.
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > ________________________________
> >> >> >> > From: knowledgeware at kccsoft.com
> >> >> >> > To: xerte at lists.nottingham.ac.uk
> >> >> >> > Date: Sat, 28 Apr 2012 12:42:30 -0700
> >> >> >> > Subject: [Xerte] Re: database.php
> >> >> >> >
> >> >> >> > The ODBC connection has not fixed the problem, unless I have the
> >> >> >> > wrong
> >> >> >> > DSN
> >> >> >> > name which I’m trying to confirm. Vince sees a PHP error, tracking
> >> >> >> > that
> >> >> >> > down
> >> >> >> > next…however the PHP all looks OK to me.
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > RonM2
> >> >> >> >
> >> >> >> >
> >> >> >> > This message and any attachment are intended solely for the
> >> >> >> > addressee
> >> >> >> > and
> >> >> >> > may contain confidential information. If you have received this
> >> >> >> > message
> >> >> >> > in
> >> >> >> > error, please send it back to me, and immediately delete it.
> >> >> >> > Please
> >> >> >> > do
> >> >> >> > not
> >> >> >> > use, copy or disclose the information contained in this message or
> >> >> >> > in
> >> >> >> > any
> >> >> >> > attachment. Any views or opinions expressed by the author of this
> >> >> >> > email
> >> >> >> > do
> >> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >> > This message has been checked for viruses but the contents of an
> >> >> >> > attachment
> >> >> >> > may still contain software viruses which could damage your
> >> >> >> > computer
> >> >> >> > system:
> >> >> >> > you are advised to perform your own checks. Email communications
> >> >> >> > with
> >> >> >> > the
> >> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> >> > legislation.
> >> >> >> >
> >> >> >> > _______________________________________________
> >> >> >> > Xerte mailing list
> >> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >> >> >
> >> >> >> > This message and any attachment are intended solely for the
> >> >> >> > addressee
> >> >> >> > and
> >> >> >> > may contain confidential information. If you have received this
> >> >> >> > message
> >> >> >> > in
> >> >> >> > error, please send it back to me, and immediately delete it.
> >> >> >> >   Please
> >> >> >> > do
> >> >> >> > not
> >> >> >> > use, copy or disclose the information contained in this message or
> >> >> >> > in
> >> >> >> > any
> >> >> >> > attachment.  Any views or opinions expressed by the author of this
> >> >> >> > email
> >> >> >> > do
> >> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >> >
> >> >> >> > This message has been checked for viruses but the contents of an
> >> >> >> > attachment
> >> >> >> > may still contain software viruses which could damage your
> >> >> >> > computer
> >> >> >> > system:
> >> >> >> > you are advised to perform your own checks. Email communications
> >> >> >> > with
> >> >> >> > the
> >> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> >> > legislation.
> >> >> >> >
> >> >> >> >
> >> >> >> > _______________________________________________ Xerte mailing list
> >> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte This message
> >> >> >> > and
> >> >> >> > any
> >> >> >> > attachment are intended solely for the addressee and may contain
> >> >> >> > confidential information. If you have received this message in
> >> >> >> > error,
> >> >> >> > please
> >> >> >> > send it back to me, and immediately delete it. Please do not use,
> >> >> >> > copy
> >> >> >> > or
> >> >> >> > disclose the information contained in this message or in any
> >> >> >> > attachment.
> >> >> >> > Any
> >> >> >> > views or opinions expressed by the author of this email do not
> >> >> >> > necessarily
> >> >> >> > reflect the views of the University of Nottingham. This message
> >> >> >> > has
> >> >> >> > been
> >> >> >> > checked for viruses but the contents of an attachment may still
> >> >> >> > contain
> >> >> >> > software viruses which could damage your computer system: you are
> >> >> >> > advised to
> >> >> >> > perform your own checks. Email communications with the University
> >> >> >> > of
> >> >> >> > Nottingham may be monitored as permitted by UK legislation.
> >> >> >> >
> >> >> >> > _______________________________________________
> >> >> >> > Xerte mailing list
> >> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >> >> >
> >> >> >> > This message and any attachment are intended solely for the
> >> >> >> > addressee
> >> >> >> > and
> >> >> >> > may contain confidential information. If you have received this
> >> >> >> > message
> >> >> >> > in
> >> >> >> > error, please send it back to me, and immediately delete it.
> >> >> >> >   Please
> >> >> >> > do
> >> >> >> > not
> >> >> >> > use, copy or disclose the information contained in this message or
> >> >> >> > in
> >> >> >> > any
> >> >> >> > attachment.  Any views or opinions expressed by the author of this
> >> >> >> > email
> >> >> >> > do
> >> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >> >
> >> >> >> > This message has been checked for viruses but the contents of an
> >> >> >> > attachment
> >> >> >> > may still contain software viruses which could damage your
> >> >> >> > computer
> >> >> >> > system:
> >> >> >> > you are advised to perform your own checks. Email communications
> >> >> >> > with
> >> >> >> > the
> >> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> >> > legislation.
> >> >> >> >
> >> >> >> >
> >> >> >> > _______________________________________________ Xerte mailing list
> >> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte This message
> >> >> >> > and
> >> >> >> > any
> >> >> >> > attachment are intended solely for the addressee and may contain
> >> >> >> > confidential information. If you have received this message in
> >> >> >> > error,
> >> >> >> > please
> >> >> >> > send it back to me, and immediately delete it. Please do not use,
> >> >> >> > copy
> >> >> >> > or
> >> >> >> > disclose the information contained in this message or in any
> >> >> >> > attachment.
> >> >> >> > Any
> >> >> >> > views or opinions expressed by the author of this email do not
> >> >> >> > necessarily
> >> >> >> > reflect the views of the University of Nottingham. This message
> >> >> >> > has
> >> >> >> > been
> >> >> >> > checked for viruses but the contents of an attachment may still
> >> >> >> > contain
> >> >> >> > software viruses which could damage your computer system: you are
> >> >> >> > advised to
> >> >> >> > perform your own checks. Email communications with the University
> >> >> >> > of
> >> >> >> > Nottingham may be monitored as permitted by UK legislation.
> >> >> >> >
> >> >> >> > _______________________________________________
> >> >> >> > Xerte mailing list
> >> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >> >> >
> >> >> >> > This message and any attachment are intended solely for the
> >> >> >> > addressee
> >> >> >> > and
> >> >> >> > may contain confidential information. If you have received this
> >> >> >> > message
> >> >> >> > in
> >> >> >> > error, please send it back to me, and immediately delete it.
> >> >> >> > Please
> >> >> >> > do
> >> >> >> > not
> >> >> >> > use, copy or disclose the information contained in this message or
> >> >> >> > in
> >> >> >> > any
> >> >> >> > attachment.  Any views or opinions expressed by the author of this
> >> >> >> > email
> >> >> >> > do
> >> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >> >
> >> >> >> > This message has been checked for viruses but the contents of an
> >> >> >> > attachment
> >> >> >> > may still contain software viruses which could damage your
> >> >> >> > computer
> >> >> >> > system:
> >> >> >> > you are advised to perform your own checks. Email communications
> >> >> >> > with
> >> >> >> > the
> >> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> >> > legislation.
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> _______________________________________________
> >> >> >> Xerte mailing list
> >> >> >> Xerte at lists.nottingham.ac.uk
> >> >> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >> >
> >> >> > This message and any attachment are intended solely for the addressee
> >> >> > and
> >> >> > may contain confidential information. If you have received this
> >> >> > message
> >> >> > in
> >> >> > error, please send it back to me, and immediately delete it. Please
> >> >> > do
> >> >> > not
> >> >> > use, copy or disclose the information contained in this message or in
> >> >> > any
> >> >> > attachment. Any views or opinions expressed by the author of this
> >> >> > email
> >> >> > do
> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >
> >> >> > This message has been checked for viruses but the contents of an
> >> >> > attachment
> >> >> > may still contain software viruses which could damage your computer
> >> >> > system:
> >> >> > you are advised to perform your own checks. Email communications with
> >> >> > the
> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> > legislation.
> >> >> >
> >> >> >
> >> >> > _______________________________________________
> >> >> > Xerte mailing list
> >> >> > Xerte at lists.nottingham.ac.uk
> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >> >
> >> >> > This message and any attachment are intended solely for the addressee
> >> >> > and
> >> >> > may contain confidential information. If you have received this
> >> >> > message
> >> >> > in
> >> >> > error, please send it back to me, and immediately delete it.   Please
> >> >> > do
> >> >> > not
> >> >> > use, copy or disclose the information contained in this message or in
> >> >> > any
> >> >> > attachment.  Any views or opinions expressed by the author of this
> >> >> > email
> >> >> > do
> >> >> > not necessarily reflect the views of the University of Nottingham.
> >> >> >
> >> >> > This message has been checked for viruses but the contents of an
> >> >> > attachment
> >> >> > may still contain software viruses which could damage your computer
> >> >> > system:
> >> >> > you are advised to perform your own checks. Email communications with
> >> >> > the
> >> >> > University of Nottingham may be monitored as permitted by UK
> >> >> > legislation.
> >> >> >
> >> >> >
> >> >>
> >> >> _______________________________________________
> >> >> Xerte mailing list
> >> >> Xerte at lists.nottingham.ac.uk
> >> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >
> >> > This message and any attachment are intended solely for the addressee
> >> > and
> >> > may contain confidential information. If you have received this message
> >> > in
> >> > error, please send it back to me, and immediately delete it. Please do
> >> > not
> >> > use, copy or disclose the information contained in this message or in
> >> > any
> >> > attachment. Any views or opinions expressed by the author of this email
> >> > do
> >> > not necessarily reflect the views of the University of Nottingham.
> >> >
> >> > This message has been checked for viruses but the contents of an
> >> > attachment
> >> > may still contain software viruses which could damage your computer
> >> > system:
> >> > you are advised to perform your own checks. Email communications with
> >> > the
> >> > University of Nottingham may be monitored as permitted by UK
> >> > legislation.
> >> >
> >> >
> >> > _______________________________________________
> >> > Xerte mailing list
> >> > Xerte at lists.nottingham.ac.uk
> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> >
> >> > This message and any attachment are intended solely for the addressee
> >> > and
> >> > may contain confidential information. If you have received this message
> >> > in
> >> > error, please send it back to me, and immediately delete it.   Please do
> >> > not
> >> > use, copy or disclose the information contained in this message or in
> >> > any
> >> > attachment.  Any views or opinions expressed by the author of this email
> >> > do
> >> > not necessarily reflect the views of the University of Nottingham.
> >> >
> >> > This message has been checked for viruses but the contents of an
> >> > attachment
> >> > may still contain software viruses which could damage your computer
> >> > system:
> >> > you are advised to perform your own checks. Email communications with
> >> > the
> >> > University of Nottingham may be monitored as permitted by UK
> >> > legislation.
> >> >
> >> >
> >>
> >> _______________________________________________
> >> Xerte mailing list
> >> Xerte at lists.nottingham.ac.uk
> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >
> > This message and any attachment are intended solely for the addressee and
> > may contain confidential information. If you have received this message in
> > error, please send it back to me, and immediately delete it. Please do not
> > use, copy or disclose the information contained in this message or in any
> > attachment. Any views or opinions expressed by the author of this email do
> > not necessarily reflect the views of the University of Nottingham.
> >
> > This message has been checked for viruses but the contents of an attachment
> > may still contain software viruses which could damage your computer system:
> > you are advised to perform your own checks. Email communications with the
> > University of Nottingham may be monitored as permitted by UK legislation.
> >
> >
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >
> > This message and any attachment are intended solely for the addressee and
> > may contain confidential information. If you have received this message in
> > error, please send it back to me, and immediately delete it.   Please do not
> > use, copy or disclose the information contained in this message or in any
> > attachment.  Any views or opinions expressed by the author of this email do
> > not necessarily reflect the views of the University of Nottingham.
> >
> > This message has been checked for viruses but the contents of an attachment
> > may still contain software viruses which could damage your computer system:
> > you are advised to perform your own checks. Email communications with the
> > University of Nottingham may be monitored as permitted by UK legislation.
> >
> >
> 
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20120429/58a73236/attachment-0001.html>