send data from vb.net to php and vice versa

Question

4.00/5 (2 votes)

See more:

hi code project member,
i have a code that send data from vb.net to PHP. but after get the data from vb.net,it will update database mysql. the problem i have is after update in mysql,how to tell the vb.net that i had updated my database..

here is my code.

activate.php

PHP

<?php
$serialnum = $_GET['ser'];
$company_name = $_GET['comp'];
$date_activate = date("Y-m-d");

$check = mysql_query("SELECT * FROM license WHERE serialnumber = '$serialnum' && status = 'DEACTIVATED'");

if($check)
{
	if(mysql_num_rows($check) == 1)
	{
	//if exist in table license,update column status = 'activate' and date_activate = now(), check again in table activate
	//check in table activate
	//if exist,means it already activate
        //if not exist,insert into table activate and
        //the problem is here how to tell vb.net that i already update database
	}
	else
	{
	//the problem is here to,how to tell vb.net that data is exist 
	
	}
}
else
{
//the problem is here to,how to tell vb.net that query failed
}
?>

this is my script in vb.net

activatefrm.vb

VB

Private Sub activateBtn_Click(sender As Object, e As EventArgs) Handles activateBtn.Click
        Process.Start("http://localhost/license/activate.php?ser=" & serialnum.Text & "&&comp=" & compname.Text)   
    End Sub

i hope codeproject member can help me. thank you.

Posted 31-Mar-13 18:37pm

xana7900

Updated 16-Oct-19 0:55am

v2

Add a Solution

2 solutions

Solution 2

hy guys any one knw about how mysql database table nd ms sql databse attach with each other

Posted 16-Oct-19 0:55am

Member 14624694

Comments

Richard Deeming 16-Oct-19 15:39pm

Your question is not a "solution" to someone else's question.

If you want to ask a question, then ASK A QUESTION[^]. But you're going to have to provide a lot more information than you have here if you want anyone to be able to help you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Accepted Answer · 2013-03-31T20:07:00

Hello,

Process.Start is not the right way to call PHP or for that matter any web resource. You need to use System.Net.HttpWebRequest instead. Here is a small snippet to demonstrate how it's done. From your PHP page you can either send tour data in CSV format, or name=value pair on each line format, or JSON format or even XML. The choice is yours.

VB

Dim strReq As String
Dim strData As String
Dim dataStream As Stream 
Dim reader As StreamReader
Dim request As WebRequest
Dim response As WebResponse

strReq = "http://localhost/license/activate.php?ser=" & serialnum.Text & "&&comp=" & compname.Text
request = WebRequest.Create(strReq)
response = request.GetResponse()
dataStream = response.GetResponseStream()
reader = New StreamReader(dataStream)
strData = reader.ReadToEnd()
reader.Close()
response.Close()

Regards,