In-line record update with jQuery and PHP

Download Exercise Files

Discussion (9 comments)

• 

  Lars Inge Holen on Thursday, 19th January 2012

  Thank you Sebastian!
  Once again - great :-)

  Reply

• 

  Sebastian Sulinski : @designtutorials on Thursday, 19th January 2012

  Thanks Lars - glad you've found it useful. Take care!

  Reply

• 

  Rakesh Singh on Tuesday, 24th January 2012

  Hello Sebastian,
  Can you please advise if you have a tutorial to create website and Database backup or if you have any plans on creating one?
  You have some wonderful tutorials on here and was hoping you would have something that can backup an entire site including database/s.
  I was hoping something with the following features.

  Save like 5 Backups and when you reach number six the first one is deleted etc
  Create zipped backups of the server files
  Email file and/or database backups to your email address
  Download created backups to your computer
  Rollback a particular backup (restore points)
  Create database backup
  Delete backup files
  Download created backup (automatically zipped for faster download)
  Rollback a particular database backup (restore points)
  Database SQL importer
  Deploy a zip file to the server
  Exclude directories, files, file extensions from your backup to make the backups smaller - Have an insert box that you type which files rather than opening a config file.
  Cronjob supported to create file and database backups or restore them
  Ajax to perform certain functions - Like a lightbox with a do you want to delete this file/folder or do you want to back this file.
  
  Thanks

  Reply

• 

  Sebastian Sulinski : @designtutorials on Tuesday, 24th January 2012

  Hi Rakesh,
  Thanks for the suggestion - there are some interesting ideas for new tutorials, but I couldn't do it as one series as considering the amount of work, that would be required to create these, it would take me a lot of time to finish it.

  I might take a few ideas from that list and create single tutorials showing how to achieve this. Time wise I can't really promise anything, but will try to cover a few of these topics in the future publications.

  Reply

• 

  Imran Khan on Monday, 2nd April 2012

  Hello Sebastian,
  
  I wanted to ask if you would be creating the tutorial suggested by Rakesh above?
  
  Their are quite a few good suggestions and was hoping you would create a tutorial series on this request.
  
  I know their is loads of work involved in this when typing and maybe you can relieve the work load by having certain parts already done and just a quick explanation would be good rather than typing everything up for example like Config, Ajax, jQuery etc.
  
  Could even use PHPMailer etc to send emails so that too would not require having video created on it.
  
  Thanks

  Reply

• 

  Sebastian Sulinski : @designtutorials on Monday, 2nd April 2012

  Hi Imran,
  I'm afraid at the moment I haven't got enough time to start on these. I'm currently working on two new series, which are still half way through.

  Reply

• 

  Imran on Monday, 2nd April 2012

  Hi Sebastian,
  
  Thank you for the update, no problems hopefully when you have some time to spare we could look forward to this brilliant tutorial.
  
  Thanks

  Reply

• 

  Qaysar Akbar on Friday, 6th April 2012

  Hi Sebastian,
  
  I was hoping you have a solution or tutorial that can help with the following query.
  
  If I have a table with records with a link to Update or delete and say I click the edit link to take me to edit page and once I have made the changes and clicked edit is their a redirect that can be used in the PHP file that will pass the link back to the pages with the list via Ajax and then pass a message the record has been updated?
  
  And if the record could not be updated it display via Ajax on the edit page the error message.
  
  I hope i'm explaining properly.
  
  Example
  
  Pages lis: - A table containing a list of pages with edit and delete links on it.
  
  When edit link is clicked it takes to edit page (via Ajax or PHP) not sure.
  
  User makes changes to the page and the page is processed via Ajax to update the records in MySQL table.
  
  If edit is successful the user is redirect to Pages List page and a custom message is displayed on the pages list page - "Record - About Page has successfully been updated.
  
  If Edit is not successful for some reason the error messages are displayed on the edit page.
  
  I hope this makes sense.
  
  Thank you

  Reply

• 

  Sebastian Sulinski : @designtutorials on Sunday, 8th April 2012

  Hi Qaysar,
  That's pretty straight forward - you just have to have two separate landing pages and based on the result and redirect user to the relevant one:

  $url = 'successful.php';
  $url2 = 'failure.php';
  
  $sql = "UPDATE ....";
  
  if (!$objDb->update($sql)) {
  	$url = $url2;
  }
  
  header("Location: $url");
  exit();
  

  Doing this with Ajax you can echo url and then use:

  jQuery.getJSON(url_to_code, function(data) {
  	window.location.replace(data.url);
  });
  

  Reply

Add a comment

Name: *	Email: *
Website:	Twitter:
Comment (no html allowed): *
Add Comment

First name: *
E-mail: *
Subscribe