Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "guestandhost";
- $password = "guestandhost";
- $dbname = "guestandhost";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- $username=$_GET['username'];
- $password=$_GET['password'];
- $sql="select * from user where username='".$username."' and password='".$password."'";
- $result = $conn->query($sql);
- $json = new SimpleXMLElement('<xml/>');
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- $mydata = $json->addChild('user');
- $mydata->addChild('id',$row['id']);
- $mydata->addChild('username',$row['username']);
- $mydata->addChild('email',$row['email']);
- $mydata->addChild('password',$row['password']);
- $mydata->addChild('name',$row['name']);
- $mydata->addChild('birthday',$row['birthday']);
- $mydata->addChild('phone',$row['phone']);
- $mydata->addChild('adress',$row['adress']);
- }
- }else {
- echo "0 results";
- }
- echo( json_encode ($json));
- ?>
Add Comment
Please, Sign In to add comment