Tuesday, 2 April 2013

52)xml parsing retrieve data from the MYSQL{Add/Delete/Update}



AppDelegate.h

@property (strong, nonatomic) IBOutlet UIWindow *window;

@property (strong, nonatomic) IBOutlet UINavigationController *nav;

@property (nonatomic, retain) NSString *apiURL;

AppDelegate.m

@synthesize apiURL;
@synthesize nav;
- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions
{
    apiURL = @"http://FolderPath/XML/";
   
    self.window.rootViewController = nav;
   
    [self.window makeKeyAndVisible];
    return YES;
}

ViewController.h

@class  ip23AppDelegate,
        Student;

@interface ip23ViewController : UIViewController    <NSXMLParserDelegate,
                                                    UITableViewDataSource,
                                                    UITableViewDelegate>
{
    ip23AppDelegate *appDel;
   
    Student *aRecord;

    NSMutableString *recordsStr;
   
    NSMutableArray *recordsArr;
}

@property (nonatomic, retain) IBOutlet UIActivityIndicatorView *processActView;

@property (nonatomic, retain) IBOutlet UITableView *recordsTblView;

@property (nonatomic, retain) IBOutlet UIBarButtonItem  *refreshBarBtn,
                                                        *addBarBtn;

- (IBAction)refreshBtnPressed:(id)sender;

- (IBAction)addBtnPressed:(id)sender;

@end

ViewController.m

#import "ViewController.h"
#import "AppDelegate.h"
#import "Student.h"
#import "MyFunctions.h"
#import "StudentCellViewController.h"

@implementation ip23ViewController

@synthesize processActView,
            recordsTblView;

@synthesize refreshBarBtn,
            addBarBtn;

- (IBAction)refreshBtnPressed:(id)sender
{
    [self initTableAndView];
}

- (IBAction)addBtnPressed:(id)sender
{
    Student *sObj = [[Student alloc] init];
    sObj.Name = @"Alex";
    sObj.Age = @"16";
    sObj.Perc = @"90.16";
   
    NSOperationQueue *queue = [NSOperationQueue new];
    NSInvocationOperation *operation = [[NSInvocationOperation alloc] initWithTarget:self selector:@selector(addRecordRequest:) object:sObj];
    [queue addOperation:operation];
}


- (void)viewDidLoad
{
    [super viewDidLoad];
   
    self.navigationItem.leftBarButtonItem = refreshBarBtn;
    self.navigationItem.rightBarButtonItem = addBarBtn;   

    appDel = (ip23AppDelegate *)[[UIApplication sharedApplication] delegate];
   
    [self initTableAndView];
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

#pragma mark - Add

- (void)addRecordResponse:(NSString *)response
{   
    if([response isEqualToString:@"OK"])
    {
        [[[UIAlertView alloc] initWithTitle:@"Success!"
                                    message:@"Record added successfully."
                                   delegate:self
                          cancelButtonTitle:@"OK"
                          otherButtonTitles:nil] show];
       
        [self initTableAndView];
    }
    else if([response isEqualToString:@"INVALID PARAMETER"])
    {
        [[[UIAlertView alloc] initWithTitle:@"Warning!"
                                    message:@"Record is not added.\nPlease varify your data."
                                   delegate:self
                          cancelButtonTitle:@"OK"
                          otherButtonTitles:nil] show];
    }
    else
    {       
        [[[UIAlertView alloc] initWithTitle:@"Warning!"
                                    message:@"Something went wrong.\nPlease try again later."
                                   delegate:self
                          cancelButtonTitle:@"OK"
                          otherButtonTitles:nil] show];
    }
}

- (void)addRecordRequest:(Student *)sObj
{
    NSString *boundary = @"---------------------------14737809831466499882746641449";
    NSString *contentType = [NSString stringWithFormat:@"multipart/form-data; boundary=%@", boundary];
    NSMutableData *body = [NSMutableData data];
   
    [body appendData:[[NSString stringWithFormat:@"--%@\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"Name\"\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[sObj.Name dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[@"\r\n" dataUsingEncoding:NSUTF8StringEncoding]];
       
    [body appendData:[[NSString stringWithFormat:@"--%@\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"Age\"\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[sObj.Age dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[@"\r\n" dataUsingEncoding:NSUTF8StringEncoding]];
   
   
    [body appendData:[[NSString stringWithFormat:@"--%@\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"Perc\"\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[sObj.Perc dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[@"\r\n" dataUsingEncoding:NSUTF8StringEncoding]];
   
   
    [body appendData:[[NSString stringWithFormat:@"--%@\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"action\"\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[@"add" dataUsingEncoding:NSUTF8StringEncoding]];
    [body appendData:[@"\r\n" dataUsingEncoding:NSUTF8StringEncoding]];
   
    // close form
    [body appendData:[[NSString stringWithFormat:@"--%@--\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]];
   
    NSString *urlString = [NSString stringWithFormat:@"%@/student.php", appDel.apiURL];
    NSMutableURLRequest *request = [[NSMutableURLRequest alloc] init];
    [request setURL:[NSURL URLWithString:urlString]];
    [request setHTTPMethod:@"POST"];
    [request addValue:contentType forHTTPHeaderField:@"Content-Type"];
    [request setHTTPBody:body];
   
    NSData *returnData = [NSURLConnection sendSynchronousRequest:request returningResponse:nil error:nil];
    NSString *returnString = [[NSString alloc] initWithData:returnData encoding:NSUTF8StringEncoding];
   
    [self performSelectorOnMainThread:@selector(addRecordResponse:) withObject:returnString waitUntilDone:NO];
}

#pragma mark - Delete

- (void)deleteRecordResponse:(NSString *)response
{
    if([response isEqualToString:@"OK"])
    {
        //Action
    }
    else
    {
        [[[UIAlertView alloc] initWithTitle:@"Warning!"
                                    message:@"Something went wrong.\nPlease try again later."
                                   delegate:self
                          cancelButtonTitle:@"OK"
                          otherButtonTitles:nil] show];
        
        [self initTableAndView];
    }
   
    //NSLog(@"%@", response);
}

- (void)deleteRecordRequest:(Student *)sObj
{
    NSString *post =[NSString stringWithFormat:@"action=delete&StudentId=%@", sObj.StudentId];
   
    NSData *postData = [post dataUsingEncoding:NSASCIIStringEncoding allowLossyConversion:YES];
    NSString *postLength = [NSString stringWithFormat:@"%d", [postData length]];
   
    NSMutableURLRequest *request = [[NSMutableURLRequest alloc] init];
    [request setURL:[NSURL URLWithString:[NSString stringWithFormat:@"%@/student.php", appDel.apiURL]]];
    [request setHTTPMethod:@"POST"];
    [request setValue:postLength forHTTPHeaderField:@"Content-Length"];
    [request setValue:@"application/x-www-form-urlencoded" forHTTPHeaderField:@"Content-Type"];
    [request setHTTPBody:postData];
   
    NSURLResponse *response;
    NSData *urlData=[NSURLConnection sendSynchronousRequest:request returningResponse:&response error:nil];
    NSString *resp = [[NSString alloc]initWithData:urlData encoding:NSUTF8StringEncoding];
   
    [self performSelectorOnMainThread:@selector(deleteRecordResponse:) withObject:resp waitUntilDone:NO];
}

#pragma mark - XML Parse

- (void)initTableAndView
{
    recordsTblView.userInteractionEnabled = NO;
   
    processActView.hidden = NO;
   
    recordsArr = [[NSMutableArray alloc] init];
   
    NSOperationQueue *queue = [NSOperationQueue new];
    NSInvocationOperation *operation = [[NSInvocationOperation alloc] initWithTarget:self selector:@selector(getApiData) object:nil];
    [queue addOperation:operation];
}

- (void)loadDataInTable
{
    recordsTblView.userInteractionEnabled = YES;   
   
    processActView.hidden = YES;
   
    [recordsTblView reloadData];
}

- (void)getApiData
{  
    NSString *myApiLink = [NSString stringWithFormat:@"%@student.php?action=list",
                           appDel.apiURL];
   
    //NSLog(@"%@", myApiLink);
    NSURL *url = [[NSURL alloc] initWithString:myApiLink];
   
    NSXMLParser *xParse = [[NSXMLParser alloc] initWithContentsOfURL:url];
           
            [xParse setDelegate:self];
   
    [xParse parse];
   
   
    [self performSelectorOnMainThread:@selector(loadDataInTable) withObject:nil waitUntilDone:NO];
}

- (void)parser:(NSXMLParser *)parser didStartElement:(NSString *)elementName namespaceURI:(NSString *)namespaceURI qualifiedName:(NSString *)qualifiedName attributes:(NSDictionary *)attributeDict
{  
    if([elementName isEqualToString:@"Student"])
    {
        aRecord = [[Student alloc] init];
            }
}

- (void)parser:(NSXMLParser *)parser foundCharacters:(NSString *)string
{
    if(!recordsStr)
            recordsStr = [[NSMutableString alloc] initWithString:string];
            else
            [recordsStr appendString:string];
}

- (void)parser:(NSXMLParser *)parser didEndElement:(NSString *)elementName namespaceURI:(NSString *)namespaceURI qualifiedName:(NSString *)qName
{
    if([elementName isEqualToString:@"Students"])
    {
                        return;
            }
            else if([elementName isEqualToString:@"Student"])
    {
                        [recordsArr addObject:aRecord];
       
                        aRecord = nil;
    }
            else
    {
        if([elementName isEqualToString:@"StudentId"] ||
           [elementName isEqualToString:@"Name"] ||
           [elementName isEqualToString:@"Age"] ||
           [elementName isEqualToString:@"Perc"])
        {
            [aRecord setValue:recordsStr forKey:elementName];
        }
            }
   
    recordsStr = nil;
}

#pragma mark - Table Methods


- (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath
{
    return 100;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
{
    return recordsArr.count;
}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath
{
    static NSString *CellIdentifier = @"Cell";
   
    UITableViewCell *cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier];
   
    Student *sObj = [recordsArr objectAtIndex:indexPath.row];   
   
    StudentCellViewController *studentCellVC = [[StudentCellViewController alloc] init];
    studentCellVC.studentObj = sObj;
   
    [cell.contentView addSubview:studentCellVC.view];
   
    return cell;
}

- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath
{
    Student *sObj = [recordsArr objectAtIndex:indexPath.row];
   
    NSOperationQueue *queue = [NSOperationQueue new];
    NSInvocationOperation *operation = [[NSInvocationOperation alloc] initWithTarget:self selector:@selector(deleteRecordRequest:) object:sObj];
    [queue addOperation:operation];
   
    [recordsArr removeObjectAtIndex:indexPath.row];
   
    [recordsTblView beginUpdates];
    [recordsTblView deleteRowsAtIndexPaths:[[NSArray alloc] initWithObjects:indexPath, nil] withRowAnimation:UITableViewRowAnimationMiddle];
    [recordsTblView endUpdates];
}

@end

MyFunctions.h

+ (NSString *)trim:(NSString *)stringToTrim;

MyFunctions.m

+ (NSString *)trim:(NSString *)stringToTrim
{
            return [stringToTrim stringByTrimmingCharactersInSet:[NSCharacterSet whitespaceAndNewlineCharacterSet]];
}

Student.h


@property (nonatomic, retain) NSString  *StudentId,
                                        *Name,
                                        *Age,
                                        *Perc;

Student.m

@synthesize StudentId,
            Name,
            Age,
            Perc;

StudentCellViewController.h

@property (nonatomic, retain) IBOutlet UILabel  *NameLbl,
                                                *AgeLbl,
                                                *PercLbl;

@property (nonatomic, retain) Student *studentObj;
@class Student;

StudentCellViewController.m

#import "StudentCellViewController.h"
#import "Student.h"
#import "MyFunctions.h"

@implementation StudentCellViewController

@synthesize NameLbl,
            AgeLbl,
            PercLbl;

@synthesize studentObj;
- (void)viewDidLoad
{
    [super viewDidLoad];
   
    NameLbl.text = [MyFunctions trim:studentObj.Name];
    AgeLbl.text = [NSString stringWithFormat:@"%@yr", [MyFunctions trim:studentObj.Age]];
    PercLbl.text = [NSString stringWithFormat:@"%@%%", [MyFunctions trim:studentObj.Perc]];
}

API

API Links

Read:
            http://Folderpath/XML/student.php?action=list

Add:
            http:// Folderpath /XML/student.php?action=add&Name=Alex&Age=16&Perc=90

Edit:
            http:// Folderpath /XML/student.php?action=edit&Name=Alex&Age=16&Perc=90.86&StudentId=3

Delete:
http:// Folderpath /XML/student.php?action=delete&StudentId=3

student-list.php

<?php
            header ("content-type: text/xml");
           
            sleep(3);
           
            echo '<?xml version="1.0" encoding="UTF-8"?>
            <Students>
                        <Student>
                                    <Name>Alan</Name>
                                    <Age>18</Age>
                                    <Perc>88.90</Perc>
                        </Student>
                        <Student>
                                    <Name>Bob</Name>
                                    <Age>20</Age>
                                    <Perc>85.60</Perc>
                        </Student>
                        <Student>
                                    <Name>Alex</Name>
                                    <Age>16</Age>
                                    <Perc>90.16</Perc>
                        </Student>     
            </Students>';
?>

student-list.xml

<?xml version="1.0" encoding="UTF-8"?>
<Students>
            <Student>
                        <Name>Alan</Name>
                        <Age>18</Age>
                        <Perc>88.90</Perc>
            </Student>
            <Student>
                        <Name>Bob</Name>
                        <Age>20</Age>
                        <Perc>85.60</Perc>
            </Student>
            <Student>
                        <Name>Alex</Name>
                        <Age>16</Age>
                        <Perc>90.16</Perc>
            </Student>     
</Students>

Student.php


<?php
            $DB_Host = "localhost";
            $DB_Name = "test_ios_trainees";
            $DB_Username = "root";
            $DB_Password = "root123";
           
            $WEBSITE_URL = "http://FolderPath/XML/";
           
            $con = mysql_connect($DB_Host, $DB_Username, $DB_Password) or die(mysql_errno());
            $db = mysql_select_db($DB_Name, $con) or die(mysql_error());
           
            $action = ( isset($_REQUEST["action"]) && trim($_REQUEST["action"]) != "" ) ? trim($_REQUEST["action"]) : "";
           
            $xmlHeader = '<?xml version="1.0" encoding="UTF-8"?>';
           
            if($action == "list")
            {
                        header ("content-type: text/xml");
                       
                        $xml = $xmlHeader;
                        $xml .= '<Students>';
           
                        $sqry = "SELECT * FROM students ORDER BY Name ASC";
                        $sres = mysql_query($sqry) or die("can not select form students - ".mysql_error());
                        while($srow = mysql_fetch_array($sres))
                        {
                                    $xml .= '<Student>';                          
                                                $xml .= '<StudentId>'.trim($srow["StudentId"]).'</StudentId>';
                                                $xml .= '<Name>'.trim($srow["Name"]).'</Name>';
                                                $xml .= '<Age>'.trim($srow["Age"]).'</Age>';
                                                $xml .= '<Perc>'.trim($srow["Perc"]).'</Perc>';
                                    $xml .= '</Student>';
                        }
                        mysql_free_result($sres);
                       
                        $xml .= '</Students>';
           
                        echo $xml;
                        exit;
            }
            else if($action == "add")
            {
                        if(        isset($_REQUEST["Name"]) && trim($_REQUEST["Name"]) != "" &&
                                    isset($_REQUEST["Age"]) && trim($_REQUEST["Age"]) != "" &&
                                    isset($_REQUEST["Perc"]) && trim($_REQUEST["Perc"]) != "")
                        {
                                    $iqry = "INSERT INTO students SET
                                                                                                                                    Name = '".trim($_REQUEST["Name"])."',
                                                                                                                                    Age = '".(int)trim($_REQUEST["Age"])."',
                                                                                                                                    Perc = '".(float)trim($_REQUEST["Perc"])."'";
                                                                                                                                                           
                                    mysql_query($iqry) or die("can not insert into students - ".mysql_error());              
                                   
                                    echo "OK";
                                    exit;                                                    
                        }
                        else
                        {
                                    echo "INVALID PARAMETER";
                                    exit;
                        }
            }
            else if($action == "edit")
            {
                        if(        isset($_REQUEST["StudentId"]) && trim($_REQUEST["StudentId"]) != "" &&
                                    isset($_REQUEST["Name"]) && trim($_REQUEST["Name"]) != "" &&
                                    isset($_REQUEST["Age"]) && trim($_REQUEST["Age"]) != "" &&
                                    isset($_REQUEST["Perc"]) && trim($_REQUEST["Perc"]) != "")
                        {
                                    $iqry = "UPDATE students SET
                                                                                                                        Name = '".trim($_REQUEST["Name"])."',
                                                                                                                        Age = '".(int)trim($_REQUEST["Age"])."',
                                                                                                                        Perc = '".(float)trim($_REQUEST["Perc"])."'
                                                                                                            WHERE StudentId = '".trim($_REQUEST["StudentId"])."'";
                                                                                                                                                           
                                    mysql_query($iqry) or die("can not update students - ".mysql_error());                                                                               
                                   
                                    echo "OK";
                                    exit;
                        }
                        else
                        {
                                    echo "INVALID PARAMETER";
                                    exit;
                        }
            }
            else if($action == "delete")
            {
                        if(        isset($_REQUEST["StudentId"]) && trim($_REQUEST["StudentId"]) != "")
                        {
                                    $iqry = "DELETE FROM students WHERE StudentId = '".trim($_REQUEST["StudentId"])."'";                                                                                                                                                         
                                    mysql_query($iqry) or die("can not delete from students - ".mysql_error());            
                                   
                                    echo "OK";
                                    exit;                                                    
                        }                     
                        else
                        {
                                    echo "INVALID PARAMETER";
                                    exit;
                        }
            }
            else
            {
                        echo "Nothing is here for you!";
                        exit;
            }
?>        
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)