<?php
$servername = ""
$username = "";
$password = "";
$dbnamee = "";
$con = new mysqli($servername, $username, $password, $dbnamee);
mysqli_set_charset($con,"utf8");
?>
<?php
include ("con.php");
$Name =$con->real_escape_string($_GET["Name"]) ;
$Password =$con->real_escape_string($_GET["Password"]) ;
$action = $_GET['action'];
switch ($action)
{
Case "InsertUser":
$q = mysqli_query($con," insert into User(Name,Password) VALUES ('$Name','$Password')");
break;
}
?>
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim InsertUserAs HttpJob
InsertUser.Initialize("InsertUser", Me)
InsertUser.download2("http://www.yoursite.com/All.php", Array As String ("action", "InsertUser","Name",Name.Text,"Password",Password.Text))
InsertUser.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية
Sub JobDone(Job As HttpJob)
If Job.Success Then
Dim res As String
res = Job.GetString
Log("Response from server: " & res)
Dim parser As JSONParser
parser.Initialize(res)
If Job.JobName="InsertUser" Then
ToastMessageShow("تمت عملية الاضافة",True)
End If
Else
ToastMessageShow("لم تتم العملية تأكد من اتصالك بالانترنت",True)
'Activity.Finish
End If
ProgressDialogHide
End Sub
<?php
include ("con.php");
$Name =$con->real_escape_string($_GET["Name"]) ;
$Password =$con->real_escape_string($_GET["Password"]) ;
$action = $_GET['action'];
switch ($action)
{
Case "InsertUser":
$q = mysqli_query($con," insert into User(Name,Password) VALUES ('$Name','$Password')");
break;
Case "SelectUser":
$q = mysqli_query($con,"SELECT * FROM User where Name like '$Name' And Password like '$Password' ");
$rows = array();
while($r = mysqli_fetch_assoc($q))
{
$rows[] = $r;
}
print json_encode($rows);
break;
}
?>
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim SelectUser As HttpJob
SelectUser.Initialize("SelectUser", Me)
SelectUser.download2("http://www.yoursite.com/All.php", Array As String ("action", "SelectUser","Name",Name.Text,"Password",Password.Text))
SelectUser.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية
Sub JobDone(Job As HttpJob)
If Job.Success Then
Dim res As String
res = Job.GetString
Log("Response from server: " & res)
Dim parser As JSONParser
parser.Initialize(res)
If Job.JobName="InsertUser" Then
ToastMessageShow("تمت عملية الاضافة",True)
End If
If Job.JobName="SelectUser" Then
Dim COUNTRIES As List
COUNTRIES = parser.NextArray 'returns a list with maps
If COUNTRIES.Size > 0 Then
Dim m As Map
m = COUNTRIES.Get(0)
Activity.Finish
StartActivity(M_Login)
Else
ToastMessageShow("تأكد من اسم المستخدم او كلمة المرور",True)
End If
End If
Else
ToastMessageShow("لم تتم العملية تأكد من اتصالك بالانترنت",True)
'Activity.Finish
End If
ProgressDialogHide
End Sub
<?php
include ("con.php");
$Name =$con->real_escape_string($_GET["Name"]) ;
$Password =$con->real_escape_string($_GET["Password"]) ;
$action =$_GET['action'];
switch ($action)
{
Case "InsertUser":
$q = mysqli_query($con," insert into User(Name,Password) VALUES ('$Name','$Password')");
break;
Case "SelectUser":
$q = mysqli_query($con,"SELECT * FROM User where Name like '$Name' And Password like '$Password' ");
$rows = array();
while($r = mysqli_fetch_assoc($q))
{
$rows[] = $r;
}
print json_encode($rows);
break;
Case "SelectUserِAll":
$q = mysqli_query($con,"SELECT * FROM User ");
$rows = array();
while($r = mysqli_fetch_assoc($q))
{
$rows[] = $r;
}
print json_encode($rows);
break;
}
?>
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim SelectUserAll As HttpJob
SelectUserAll.Initialize("SelectUserAll", Me)
SelectUserAll.download2("http://www.yoursite.com/All.php", Array As String ("action", "SelectUserAll"))
SelectUserAll.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية
Sub JobDone(Job As HttpJob)
If Job.Success Then
Dim res As String
res = Job.GetString
Log("Response from server: " & res)
Dim parser As JSONParser
parser.Initialize(res)
If Job.JobName="InsertUser" Then
ToastMessageShow("تمت عملية الاضافة",True)
End If
If Job.JobName="SelectUser" Then
Dim COUNTRIES As List
COUNTRIES = parser.NextArray 'returns a list with maps
If COUNTRIES.Size > 0 Then
Dim m As Map
m = COUNTRIES.Get(0)
Activity.Finish
StartActivity(M_Login)
Else
ToastMessageShow("تأكد من اسم المستخدم او كلمة المرور",True)
End If
End If
If Job.JobName="SelectUserAll" Then
Dim Name,Password As String
CustomListView1.Clear
Dim COUNTRIES As List
COUNTRIES = parser.NextArray 'returns a list with maps
For i = 0 To COUNTRIES.Size - 1
Dim m As Map
m = COUNTRIES.Get(i)
Name = m.Get("Name")
Password = m.Get("Password")
dim id as int = m.Get("id")
CustomListView1.AddTextItem(Password & " / " & Name ,id)
Next
End If
Else
ToastMessageShow("لم تتم العملية تأكد من اتصالك بالانترنت",True)
'Activity.Finish
End If
ProgressDialogHide
End Sub
'التعديل
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim UpdateUser As HttpJob
UpdateUser.Initialize("UpdateUser", Me)
UpdateUser.download2("http://www.yoursite.com/All.php", Array As String ("action", " UpdateUser","Name",Name.Text,"Password",Password.Text,"id",id.Text))
UpdateUser.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية
'الحذف
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim DeleteUser As HttpJob
DeleteUser.Initialize("UpdateUser", Me)
DeleteUser.download2("http://www.yoursite.com/All.php", Array As String ("action", " DeleteUser","id",id.Text))
DeleteUser.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية
<?php
include ("con.php");
$Name =$con->real_escape_string($_GET["Name"]) ;
$Password =$con->real_escape_string($_GET["Password"]) ;
$action =$_GET['action'];
$id = $_GET['id'];
switch ($action)
{
Case "InsertUser":
$q = mysqli_query($con," insert into User(Name,Password) VALUES ('$Name','$Password')");
break;
Case "SelectUser":
$q = mysqli_query($con,"SELECT * FROM User where Name like '$Name' And Password like '$Password' ");
$rows = array();
while($r = mysqli_fetch_assoc($q))
{
$rows[] = $r;
}
print json_encode($rows);
break;
Case "SelectUserِAll":
$q = mysqli_query($con,"SELECT * FROM User ");
$rows = array();
while($r = mysqli_fetch_assoc($q))
{
$rows[] = $r;
}
print json_encode($rows);
break;
Case "UpdateUser":
$q = mysqli_query($con," update User set Name='$Name',Password = '$Password' where id=$id ");
break;
Case "DeleteUser":
$q = mysqli_query($con," Delete From User where id=$id ");
break;
}
?>
*/المثال سيكون على الاضافة
Insert
php*/
<?php
include ("con.php");
$Name =$con->real_escape_string($_POST["Name"]) ;
$Password =$con->real_escape_string($_POST["Password"]) ;
$action = $_POST['action'];
switch ($action)
{
Case "InsertUser":
$q = mysqli_query($con," insert into User(Name,Password) VALUES ('$Name','$Password')");
break;
}
?>
'وفي جانب
'B4a
'كون الكود
ProgressDialogShow2("........جاري تحميل البيانات ",False)
Dim InsertUserAs HttpJob
InsertUser.Initialize("InsertUser", Me)
InsertUser.PostString("http://www.yoursite.com/All.php", "action="&"InsertUser"&"&Name="&Name.Text&"&Password="&Password.Text))
InsertUser.GetRequest.Timeout=15000 ' مهلة الاتصال بالخادم 15000=15 ثانية