Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently November 10th, 2024, 8:44 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Online database
PostPosted: January 15th, 2017, 11:07 pm 
Offline

Joined: February 6th, 2015, 10:16 am
Posts: 21
Opus: opus pro 9.75
OS: windows 10
Hello,
Anyone succed to create an online database (MySql) following the tutorial ? I follow it closely, step by step, but I failed to have succes... I worked on localhost.
Any kind of help, or an other tutorial would be appreciated !
Best regards,


For this message Delco44 has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 16th, 2017, 9:20 am 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
Please setup a User Profile (Top Right) including Opus Version.

These is a very broad and complex topic - you need to be more specific in your post. What tutorial, what publication type and any code examples or screen shots to show what you've done so far and what is failing.

</mack>

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
 Post subject: Re: Online database
PostPosted: January 16th, 2017, 11:21 am 
Offline

Joined: February 6th, 2015, 10:16 am
Posts: 21
Opus: opus pro 9.75
OS: windows 10
Hello Mackavi,

Thank you for your answer. I have updated my profile.

The tutorial is : "Using a Web Database". About the publication, I just follow line by line the tutorial and try it on localhost. The issue is that informations entered in text box are not sent to database. As I said, I strictly follow the tutorial.
Best regards,


For this message Delco44 has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 17th, 2017, 10:23 am 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
I can't see a 'Using a Web Database' tutorial - do you have a link?

Also, the publication type - Executable, Flex, HTML5 or Android?

</mack>

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 12:22 am 
Offline

Joined: February 6th, 2015, 10:16 am
Posts: 21
Opus: opus pro 9.75
OS: windows 10
Sorry for my late answer, I was away from home for the week.
The link is : http://www.digitalworkshop.com/support/tutorials-index.shtml

It is a tutorial on opus pro site. Publication type : HTML5


For this message Delco44 has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 9:31 am 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
Okay, which web server software are you using?

</mack>

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 12:31 pm 
Offline

Joined: February 6th, 2015, 10:16 am
Posts: 21
Opus: opus pro 9.75
OS: windows 10
I work on localhost, using XAMPP, database created with phpmyadmin.


For this message Delco44 has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 1:18 pm 
Offline

Joined: August 21st, 2012, 5:36 pm
Posts: 20
Location: Portugal
Opus: OPUS PRO v9.6
OS: Windows 8 x64
<?php
$tabela = $_POST['tabela'];
$data = $_POST["data"];
$hora03 = $_POST["03hora"];
$dir03 = $_POST["03dir"];
$vel03 = $_POST["03vel"];
$raj03 = $_POST["03raj"];

$hora06 = $_POST["06hora"];
$dir06 = $_POST["06dir"];
$vel06 = $_POST["06vel"];
$raj06 = $_POST["06raj"];

$hora09 = $_POST["09hora"];
$dir09 = $_POST["09dir"];
$vel09 = $_POST["09vel"];
$raj09 = $_POST["09raj"];

$hora12 = $_POST["12hora"];
$dir12 = $_POST["12dir"];
$vel12 = $_POST["12vel"];
$raj12 = $_POST["12raj"];

$hora15 = $_POST["15hora"];
$dir15 = $_POST["15dir"];
$vel15 = $_POST["15vel"];
$raj15 = $_POST["15raj"];

$hora18 = $_POST["18hora"];
$dir18 = $_POST["18dir"];
$vel18 = $_POST["18vel"];
$raj18 = $_POST["18raj"];

$hora21 = $_POST["21hora"];
$dir21 = $_POST["21dir"];
$vel21 = $_POST["21vel"];
$raj21 = $_POST["21raj"];

$hora24 = $_POST["24hora"];
$dir24 = $_POST["24dir"];
$vel24 = $_POST["24vel"];
$raj24 = $_POST["24raj"];

$aviso = $_POST["aviso"];

$DBhost = "hosting.com";
$DBuser = "user";
$DBpass = "password";
$DBName = "database_name";

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);
$search = "SELECT * FROM $tabela WHERE data = '$data';

if(mysql_num_rows ($search) > 0 )
{
$query = "INSERT INTO $tabela (data, 03hora, 03dir, 03vel, 03raj, 06hora, 06dir, 06vel, 06raj, 09hora, 09dir, 09vel, 09raj, 12hora, 12dir, 12vel, 12raj, 15hora, 15dir, 15vel, 15raj, 18hora, 18dir, 18vel, 18raj, 21hora, 21dir, 21vel, 21raj, 24hora, 24dir, 24vel, 24raj ,aviso) VALUES ('$data','$hora03','$dir03','$vel03','$raj03','$hora06','$dir06','$vel06','$raj06','$hora09','$dir09','$vel09','$raj09','$hora12','$dir12','$vel12','$raj12','$hora15','$dir15','$vel15','$raj15','$hora18','$dir18','$vel18','$raj18','$hora21','$dir21','$vel21','$raj21','$hora24','$dir24','$vel24','$raj24','$aviso')";

mysql_query($query, $connect);
}
else
{
$query="UPDATE $tabela SET 03dir='$dir03', 03vel='$vel03', 03raj='$raj03', 06dir='$dir06', 06vel='$vel06', 06raj='$raj06', 09dir='$dir09', 09vel='$vel09', 09raj='$raj09', 12dir='$dir12', 12vel='$vel12', 12raj='$raj12', 15dir='$dir15', 15vel='$vel15', 15raj='$raj15', 18dir='$dir18', 18vel='$vel18', 18raj='$raj18', 21dir='$dir21', 21vel='$vel21', 21raj='$raj21', 24dir='$dir24', 24vel='$vel24', 24raj='$raj24', aviso='$aviso' WHERE data='$data'";

mysql_query($query, $connect);
}

mysql_close($connect);

?>


For this message JATBorges has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 1:26 pm 
Offline

Joined: August 21st, 2012, 5:36 pm
Posts: 20
Location: Portugal
Opus: OPUS PRO v9.6
OS: Windows 8 x64
opus action


You do not have the required permissions to view the files attached to this post.


For this message JATBorges has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Online database
PostPosted: January 20th, 2017, 2:21 pm 
Offline

Joined: February 6th, 2015, 10:16 am
Posts: 21
Opus: opus pro 9.75
OS: windows 10
Thank you JATBorges !
I will try your example.
Have a good day.
Regards,


For this message Delco44 has been thanked by : mackavi


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group