Digital Workshop

Good Day,

Please help me, this is my last hurdle before success (Thanks to Mackavi - wish I had his knowledge and understanding)

Opus Tutorials is more a headache then help...
Tutorial 1 of Opus Web Databasing -- they left out a bracket
Tutorial 2 they insert a random n and
Tutorial 3 they left ' ' out of the $storedpassword=$resultRow[ userpassword ];

Maybe they do it deliberate maybe not, but for a beginner like me that paid for this software I think that is a bit cruel, it took me 4 days to find the mistakes haha

Enywayz on the last tutorial I modified a bit to display the details in the database of Just the User that is trying to Login

My code:



But with no luck...yet again.

Whenever I changed $user ($query = "SELECT * FROM clients_1 WHERE Name='$user'";) to a user in my database eg. 'John'
it works fine. It looks like the variable ($user = $_POST['user'];) do not hold the information as expected.

Or Am I completely of the path.

Herewith the Login and PHP Hyperlink: http://www.cbt44.com/login.htm and http://www.cbt44.com/insert_3.php

Your submit button appears to have a Post Web Data action followed by a Launch Web Page to the same script used in the previous action.

Basically, you send the data but then change to the PHP page.

You're supposed to send the data and then wait until it comes back and then use it. There is no reason to load the insert_3.php, it does the hard work on the server not your browser.

As for Robin's Tutorial, as with all posts, it was designed to answer questions at the time of posting, not 11 years later.

</mack>

Hi Mackavi thank you for replying,

Is interaktiv your company and what service do you offer?

As per my post:

Yes I know, but couldn't find support from Opus (send them a couple of emails) so I just took a change on old posts, because I need it working by today, but it looks like I need a miracle now.

Back to my dilemma,

I forgot I had to launch action in, I was just checking if the variable where sending correctly. I had it without the Launch, and nothing worked.

I changed the button back to "Go to Page" --> account.htm, but nothing displays ( and I am putting the correct database user and password in )

It seems like the variables user and pass is empty?? because if I change the variables to something like "John" and "password123" (not variables but String) my code works fine.

It looks like the problem is with sending the variables from Opus to insert_3.php.

Please help me sir, I am well under pressure because of this.

Yes, Interaktiv is my company. We offer full support for development of e-learning and application development including Opus Pro / HTML.

You are right, the post is not sending anything to the script.

It should look like this:

http://sandbox.interaktiv.co.uk/1/post.jpg

With your URL of course, but the label and variable columns should match what you are using in Opus and the PHP script.

</mack>

It does match:

I can't attach n screenshot it won't let me or I am too dumb but it basicly looks like this:

String | Variable
user | user
pass | pass

Herewith link:

http://www.cbt44.com/pic1.htm

I changed the String | Variable to
name | user
password | pass

and the php too:

<?php

$user = $_POST['name'];
$pass = $_POST['password'];


$DBhost = "localhost";
$DBuser = "___";
$DBpass = "___";
$DBName = "qxeacpqg_myDB";

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);
$query = "SELECT * FROM clients_1 WHERE Name='$user'";
$result = mysql_query($query, $connect);

$row = mysql_fetch_array($result);
$data = "&var1=".$row['Name']."&var2=".$row['Surname']."&var3=".$row['Country']."&var4=".$row['Address'];
echo $data;

?>

but no luck

Is console throwing any errors?

If you haven't used a console - watch this: https://www.youtube.com/watch?v=B-L_aGl ... q&index=13

</mack>

Forget above, I can test that and it's clear.

</mack>

Okay dit the youtube video, got the console and got this via the console:

&var1=t&var2=t&var3=t&var4=null

This is exactly what I need, but when I go to http://www.cbt44.com/account.htm on the address bar, nothing displays, it is suppose to display.
t t t null

Does it matter if my variables in opus is set to page and not publication

Okay, I've moved the video lessons around and uploaded Lesson 15 as PHP communication.

Have a go at following the lesson to see if you can get it working.

</mack>

Good Day Mr Mackavi,

Thank you so much for all your help on this subject and especially for the video tutorial. Now I understand how it works.

Without you I could never have figured it out.

Will be in touch.

Glad it helped.

</mack>