从PHP网页检索用户信息到VB.NET表单 [英] Retrieve users info from PHP webpage to VB.NET form

问题描述

大家好我拥有这个php代码

Hi all i have i have this php code

<?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

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

能够在浏览器的空白页面上看到用户详细信息

我在浏览器上看到的相同信息我想让它显示在vb.net中表格





数据库结构

http：//i.imgur .com / 3GnYZFl.png



表格示例

http：// i .imgur.com / jISC9J3.png



有没有人有这个功能的vb.net代码



我尝试过：

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

$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

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

能够在浏览器的空白页面上看到用户详细信息

我在浏览器上看到的相同信息我想让它显示在vb.net中表格





数据库结构

http：//i.imgur .com / 3GnYZFl.png



表格示例

http：// i .imgur.com / jISC9J3.png

推荐答案

app = mysql_connect（ localhost， dbuser， dbpass）或 die（' 无法连接到数据库'。 mysql_error（））;
mysql_select_db（ database）;

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

user =

user =

_GET [ username];

_GET["username"];

这篇关于从PHP网页检索用户信息到VB.NET表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！