Pages: [1] 2   Go Down
Author Topic: (Urgent) Arduino -> Vb 6.0 -> Sql + php  (Read 2096 times)
0 Members and 1 Guest are viewing this topic.
Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hi, all
need your help..
how to connect vb 6.0 to sql and php ??
Logged

0
Offline Offline
Edison Member
*
Karma: 7
Posts: 1411
Arduino rocks
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Does this have anything to do with Arduino?
Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hi,, florinc
I use Arduino to detect temperature in CPU, i use sensor DS18B20..
I have finished to send data from arduino to vb 6..

now i need help,
to send data to sql + php??
do you have any idea florinc???

Thanks
Murinto
Logged

Switzerland
Offline Offline
Faraday Member
**
Karma: 96
Posts: 4702
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Ask this on a VB6 forum. This is not related to Arduino.
Logged

Gosport, UK
Offline Offline
Faraday Member
**
Karma: 19
Posts: 3114
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You're best bet, given that you have already read data from the Arduino into VB, would be to ask at a VB forum.

Slightly off-topic, why are so many people still using VB6? Is it because it was the last native code version, or is there some other reason?
Logged

0
Offline Offline
Edison Member
*
Karma: 7
Posts: 1411
Arduino rocks
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

I imagine you want to provide the temperature data you collected (with Arduino) when there is an http request.
This is how I would do it: get VB to write the data to database (sql), then write the php page to retrieve data from the database (sql).

I don't think you will get anyone around here to write the php/sql code for you though. There must be plenty of samples out there.
Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

To dxw00d and pylon : Thanks brother,,, do you know the address of the site forum...

To florinc :Thats right bro,, can you help me to finished this project??


 
Logged

0
Offline Offline
Edison Member
*
Karma: 7
Posts: 1411
Arduino rocks
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
can you help me to finished this project
I googled it for you:
http://www.roseindia.net/sql/mysql-example/php-sql-example.shtml
http://www.webdatabasebook.com/2nd-edition/examples/index.html
Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote

Thankss very much florinc... smiley
I will learn php and sql programming...
 smiley
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 548
Posts: 46026
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
I will learn php and sql programming...
So, you're VB application is going to create a PHP script to write to a MySQL database, and execute that, instead of executing the instructions to write directly to a SqlServer database?

Well, good luck with that.

Don't get me wrong. I like PHP and MySQL. But, unless you are using PHP to communicate with the serial port (and that does not work on Windows), then using PHP to communicate with the database is just an unnecessary complexity. If you are even considering using VB6, then clearly you are on Windows, and PHP is not the right tool (for accessing the serial port/data).
Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Don't get me wrong. I like PHP and MySQL. But, unless you are using PHP to communicate with the serial port (and that does not work on Windows), then using PHP to communicate with the database is just an unnecessary complexity. If you are even considering using VB6, then clearly you are on Windows, and PHP is not the right tool (for accessing the serial port/data).


I use Wamp Server (phpmyadmin) ..
First I transfer data from Arduino to visual Basic 6.
Then immediately write the data to the database server.
continued from the database that displays the results of the temperature sensor to the website ..

If that's principally, if I could?

Thanks...
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 548
Posts: 46026
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
First I transfer data from Arduino to visual Basic 6.
Then immediately write the data to the database server.
Which database? MySQL or SQLServer? I don't know if MySQL provides a way for VB applications to write to the database. I know that SQLServer does.

PHP is not involved in the data acquisition process at all, if I understand you correctly.

PHP is involved in the data display process, but that is a completely separate issue. Making PHP get data from a SQLServer instance might be an interesting challenge.
Logged

0
Offline Offline
Edison Member
*
Karma: 7
Posts: 1411
Arduino rocks
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
I don't know if MySQL provides a way for VB applications to write to the database
Through ODBC (on Windows) you can get access to any database/datasource you like for which ODBC drivers are provided, including MySQL.

Quote
Making PHP get data from a SQLServer instance might be an interesting challenge.
http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx
Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 28
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Through ODBC (on Windows) you can get access to any database/datasource you like for which ODBC drivers are provided, including MySQL.

ODBC ??
I do not know about it. can you explain about it???
Logged

Gosport, UK
Offline Offline
Faraday Member
**
Karma: 19
Posts: 3114
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

ODBC - Open DataBase Connectivity - http://en.wikipedia.org/wiki/ODBC

Basically it's an abstraction layer that sits between an application and a database engine (Oracle RDBMS, MS SQL Server, mySQL, MS Access, and many others). It means the application doesn't need to know the specifics of the DB engine. Theoretically, if the application only issued ANSI SQL statements, then ODBC would allow any ANSI SQL DB engine to be targeted, without changes to the application.
Logged

Pages: [1] 2   Go Up
Jump to: