Retrieval issue

Hi,

So, at the end of your code, is $prod an array of titles, or descriptions?

Are you trying to retrieve all of the file names from CMSB that match that array of titles?

Let me know and we'll figure out a solution.

Hi Jason

$Products is a string whose content is similar to the following:

Price::Qty::Code::Description::Flags|25.00::1::CD001::Closing the Baldwin Hospital::{GST}{TEST}|15.00::1::CD001::Formulating a Provincial Budget, revised::{GST}{TEST}

My script isolates the "Description" field and creates an array, $prod, which is the title of the case studies .

Based on the purchased titles, I want to retrieve the filenames from cmsb.

If you wish, you can try it out on the site (not yet in production, so don't worry about being charged anything! Use 4545454545454545 for the credit card.)

http://www.ipac.ca/casestudies

Search for a case study, add it to the cart, view the cart and checkout. The output of the script will be sent to your web page.

Hi,

Okay, what we can do is use the information in $prod to create a list that we can search the database with:

First, we use this code:
$list="(";
foreach($prod as $p){
if($list=="("){
$list.="'".mysql_escape($p)."'";
}
else{
$list.=",'".mysql_escape($p)."'";
}
}

$list.=")";

This will produce a string that would look something like this for example:
('Administrative In-Basket Exercise','The Commissioner\'s Dilemma')

Once we have this, we can use it to do a search in the database. The getRecords would look something like this:

list($records,$metadata)=getRecords(array(
'tableName'=>'listings',
'allowSearch'=>false,
'where'=>"title IN ".$list,
));

Obviously you'd have to change names in order to make it match what you have in your database.

Give that a try and let me know if that does what you're looking for.

Hi,

You may have an old version of the database functions library. But it's okay, just replace the first bit of code I gave you with this:

$list="(";
foreach($prod as $p){
if($list=="("){
$list.="'".mysql_real_escape_string($p)."'";
}
else{
$list.=",'".mysql_real_escape_string($p)."'";
}

}

$list.=")";

Give that a try and let me know if it works for you.

Jason: looks like I may have to pass the db credentials?? (BTW, I am using v2.03)

I get the following error msgs:

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 25

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 25

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Fatal error: Call to undefined function: getrecords() in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 35

Hi,

Could you attach the file you're working with so I can take a closer look.

Thanks.

Jason: Made some changes to the file (see attached).

The errors I am now getting are:

Notice: Undefined variable: list in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 12
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY dragSortOrder DESC' at line 3

Jason: I made another change (see attached file) and get the foll error/output:

Notice: Undefined variable: description in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 23
Notice: Undefined variable: description in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 24

Closing the Baldwin Hospital
Formulating a Provincial Budget, revised