Digital Workshop

Hi All

I used the post web tutorial and it seems very explanatory , BUT i get a problem when i try and read back from the database ......I can send to it fine but pulling the data back wont happen OR wont display.

Is there away to see if you are getting an error from the script that pulls the data from the DB ?

Confused..----->

below is the script for pulling the information BUT how does my PUB aquire that information

<?php

$DBhost = "localhost";
$DBuser = "Datausername";
$DBpass = "password";
$DBName = "underwar_mydb";

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);
$query = "SELECT * FROM employees";
$result = mysql_query($query, $connect);

$row = mysql_fetch_array($result );
$data = "&first=".$row['first']."&last=".$row['last']."&address=".$row['address']."&position=".$row['position'];
echo $data

?>

Could some one explain the fetch process....

Al Barnes

Off topic but...

I wouldn't include your actual database login details openly on a forum. In fact, they should not be in the php script at all.

login details should be in a folder outside the web servers' document root and then use an 'include' in your php file.

Mack

Duely noted.........thought i put the generic 1 up

Al

Al,

I think there were some recent posts on php stuff.

Hi Al,

The script is fine and works with both Opus Actions and Opus Script.

Use something like:

var newData = InternetPostData("http://localhost/joomla/demo.php",false,true)


Debug.trace(newData.first)

to recall the data.

Basically, the echo $data bit in the PHP script is passing an object back to Opus. You then access the properties of that object using OOP.

You can see the object in action by simply running the PHP script from the URL.

Mack

P.S T&C = terms and conditions

First off Thanks Mack and Guys

I realise this project looks over my head , but it's a challenge i have to take . OK mack where do i run that test script from ?

UPDATE <-----------------------------
Just by chance i saw an Icon saying for setup of remote servers click here . So i clicked and saw that it asked for server domain info for the contacting server . I went in and white listed my Class C IP's and VOLA i see data returing LOL .

Question ? : it says i have 4 records and i tried submiting a new one and it still displays the old one ? i guess it needs some kinda of a refresh...

You guys must hate a newbie like me , full of piss and vinager and 1 million questions ( smile )..

Al

It Friday, and I'm getting muddled.

You run the php script from a folder inside your root - but the password bit should be outside.

You run the script-bit that I posted from your Opus page but pointing it at the URL for your PHP file.

Changed the remote server??? Are you talking about the cPanel from your webhost?

Mack

Sorry to fry your Brain mack ,

Yea , the web panel at my host had an area about remote servers and the database . I went in and saw it had an allow area, so i allowed my class C IP's and it allowed the data to return to me....

SO the TEST/Tutorial worked <------------------
means i have to setup my own WEB server with Mysql though , so i can control it myself . I will start playing with it and see if i can figure out how to get it to keep sending me the newest record LOL ( already tried and failed ) it just keeps handing me the first 1 )...

So i will stand by untill you have a reasonable second to think..

Seriously , THANKS

Al

Definitely fryday

Still lost. The PHP script should be on your webserver like so:

http://www.underware.ca/database.php

The Opus publication should call the URL above.

There is no need to provide remote access to your databases. A PHP script in your webserver root has access already.

Mack

Hi Mack,

Yes i have all scripts in the propper place ...

The script topost the data worked fine , the problem was to retrieve it . It wouldn't work even though i posted the script and all said it was fine . I then remembered a small icon in the web menu at my providers saying " REMOTE MYSql " i went to it and it said that i must assign access to the database by IP so as to cleaar their FIREwall......I did it

Now my Pubs accepts data back from the database , i find this kinda weird as it cant function that way as it would mean i would have to list every IP in the world so as to access my DB LOL....

I will attach a jpg of my web menu at my providers

I used PHPadmin to set the DB in[/img]

Hi Mack,

Yes i have all scripts in the propper place ...

The script topost the data worked fine , the problem was to retrieve it . It wouldn't work even though i posted the script and all said it was fine . I then remembered a small icon in the web menu at my providers saying " REMOTE MYSql " i went to it and it said that i must assign access to the database by IP so as to cleaar their FIREwall......I did it

Now my Pubs accepts data back from the database , i find this kinda weird as it cant function that way as it would mean i would have to list every IP in the world so as to access my DB LOL....

I will attach a jpg of my web menu at my providers

I used PHPadmin to set the DB in[/img]

Hi Al,

Remote Access shouldn't even figure into the equation. It to allow outside clients / servers access to the databases on your web providers server.

For example, I could run a database management tool from my office and connect to a database host by my web provider 1&1 or I could run a PHP script from the server in the my office and connect to a remote database.

Both the reading & writing PHP scripts that you are using should already on the same server hosting the database and thus remote access is not necessary and a very very bad idea to have to give out usernames / passwords to everybody you think needs access.

Try out the attached IMP. It should return the data from a database on my webserver and doesn't need remote access.

Mack

I tried it out and accessed it fine ,

I have just loaded a Web server software and i will get it ready for PHP and MY_Sql that way i 2 will be able to control it better , i also needed the web software for another use.....

Thanks for the Time Mack..............

Al

ps: taking the rest of the weekend off , will start training again on monday LOL