Click here to Skip to main content
15,889,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all i have i have this php code


PHP
<?php

$app=mysql_connect ("localhost", "dbuser","dbpass") or die('Cannot connect to the database ' . mysql_error());
mysql_select_db ("database");

$user = $_GET["username"];
$pass = $_GET['password'];
$mail = $_GET['email'];
$cell = $_GET['phone'];
$start = $_GET['register'];
$end = $_GET['expire'];

$query  = "SELECT username, password, email, phone, register, expire FROM user WHERE username='$user' GROUP BY username asc";
$result = mysql_query($query,$app);
$row = mysql_fetch_row($result);
echo $row[0] . '<br />' .
$row[1] . '<br />' .
$row[2] . '<br />' .
$row[3] . '<br />' .
$row[4] . '<br />' .
$row[5] . '<br />' .
$row[6] . '<br />' .
mysql_close($app);

?>



if i follow the link

VB
("http://example.com/account.php?username=" & TextBox1.Text)


im able to see the users details on a blank page in the browser
the same information i see on the browser i want it to get displayed in the vb.net form


the database structure
http://i.imgur.com/3GnYZFl.png

example of the form
http://i.imgur.com/jISC9J3.png

does anyone have vb.net code for this function

What I have tried:

PHP
<?php

$app=mysql_connect ("localhost", "dbuser","dbpass") or die('Cannot connect to the database ' . mysql_error());
mysql_select_db ("database");

$user = $_GET["username"];
$pass = $_GET['password'];
$mail = $_GET['email'];
$cell = $_GET['phone'];
$start = $_GET['register'];
$end = $_GET['expire'];

$query  = "SELECT username, password, email, phone, register, expire FROM user WHERE username='$user' GROUP BY username asc";
$result = mysql_query($query,$app);
$row = mysql_fetch_row($result);
echo $row[0] . '<br />' .
$row[1] . '<br />' .
$row[2] . '<br />' .
$row[3] . '<br />' .
$row[4] . '<br />' .
$row[5] . '<br />' .
$row[6] . '<br />' .
mysql_close($app);

?>



if i follow the link

VB
("http://example.com/account.php?username=" & TextBox1.Text)


im able to see the users details on a blank page in the browser
the same information i see on the browser i want it to get displayed in the vb.net form


the database structure
http://i.imgur.com/3GnYZFl.png

example of the form
http://i.imgur.com/jISC9J3.png
Posted
Updated 5-Mar-17 12:43pm

Sorry for the double post had to re-upload the images

the database structure
http://i.imgur.com/3GnYZFl.png

example of the form
http://i.imgur.com/jISC9J3.png
 
Share this answer
 
Comments
Dave Kreskowiak 5-Mar-17 18:17pm    
You posted this as an answer to your own question.
Google for "C# MySQL tutorials".
 
Share this answer
 
Hi david thanks for the Reply

thing is I can do this via MySql.Data on vb.net without using php

but the thing is i want to retrieve the users information
from a php webpage to the vb.net application

and google was'nt much help, hence i decide to ask for assistance here

thanks
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900