Digital Workshop

Dear all,

I originally posted this in the basics section as I consider myself a novice with regards to Opus, but because it contains a database issue, I've now put in here.

I've got a web based publication to interact with a mysql database (login etc), but I just cannot populate a listbox. I've done this in the past with access with a .exe publication, but I am completely stumped with mysql. I've been trying for days with all sorts of variations but I just cannot get it to populate a list box. I know it will be something quite easy, unless you are a novice, but I just do not know where to turn. Any help would be enormously appreciated.

Heres hoping in advance,

Simon

Hi Simon,

I've had a quick peek, but it's not a simple fix as there seems to be a lot going.

I cannot tell whether the SQL works as it's not pointing at your database, but you seem to be trying to return all rows in the PHP using a loop. This won't work with Opus, you need to return one row at a time or do some clever scripting to build one hell of an array to hold all data as the string. The other bit to populate the box does actually work - sort of. It'll put the value varTwo1 into the box. But then you have some unused function script dropped in that does nothing (?).

I'd take a step back and create a static array such as myList = new Array(1,2,3,4,5,6)

Then solve the script to get the values into the listbox.

Once you've got that working, work on getting the database values in to an (the) array and then connect the two.

Regards,

Mack

Thanks Russell,

I've used the php scripting advice in the tutorials to send and receive info for individual records and it's working great.

I was hoping to go one step further by using a query with the variable from the first list box to send back the info to populate the second listbox from an array.

I've not used php or mysql before, but have previously used this function with access, again by using advice gained in the forum.

The webhost that I am using offers both mysql and SQL server databases. Would it be any easier if I downloaded the ODBC driver for mysql and basically replaced the DSN location? As mentioned, I am a novice so may be talking gibberish.

Regards

Simon

Dear all,

Near yet so far. If I put in an actual value from the database into the php page (as below) everything works great and populates the listbox. However if I replace the Actual_variable with $HTTP_POST_VARS['text_input_variable']; nothing happens?


PHP Page
<?php
$enquiry = 'Actual_value';

$DBhost = "databaselocation";
$DBuser = "username";
$DBpass = "password";
$DBName = "dbname";

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);

$query = "SELECT three FROM tbl WHERE two LIKE '$enquiry'";
$result = mysql_query($query, $connect);

while ($row = mysql_fetch_assoc($result)){

echo $row['three']."\n";}

?>

This returns to a variable called test.


To populate the listbox

Listbox1.SetSelection(0, -1);
Listbox1.ReplaceSelection("");

wait(0)

var myList = test.split(String.fromCharCode(10))

Listbox1.ReplaceSelection(myList.join(String.fromCharCode(10)))
function removeElement(x)
{
var t = 0
if (myList.length > 1)
{
for (i=0;i<myList.length;i++)
{
i == x ? t = 1 :myList[i-t] = myList[i]
}
myList.length = myList.length-1
Listbox1.SetSelection(0,-1)
if (x == 0) Listbox1.ReplaceSelection("")
Listbox1.ReplaceSelection(myList.join(String.fromCharCode(10)))
}
Listbox1.SetListBoxSelection(-1)
}

Any reason why it's not reading the posted variable yet everything works if it is typed in on the PHP page. I'm baffled and look forward to any advice.

Best regards

Simon

Use $_POST[] instead.

Mack

Thanks Mack,

As yet no joy with it, but I've just tried a few variations. Unfortunately my brain is now fried and I'm afraid my variations will mess up the original script, so I'll try again in the morning.

Many thanks.

Simon

Doesn't need varying.

Here's a simple example running off a basic script on our server.

Mack

Thanks again.

Had a quick play and of course yours worked perfectly. It's something I must be doing in the script somewhere so will will work on eliminating the mistakes tomorrow. Once again, many thanks.

Simon

Dear Mack,

Thanks for your advice. The problem was in all the changes I had made, the problem was on the Post Web Data source page where I was trying to send a variable and not a string. When I changed it back to sending a string, it all worked fine. D'oh!

Thanks for the help.

Best regards

Simon