Greenway's Forum Posts

• • Greenway
  • 
  • • Joined 25 Aug, 2012
    • 
    • 1 topics • 3 posts
  • 1

  • 2 Mar, 2015
  • Quote

  thanks a lot, I will figure out from here, it was very helpfull anyway!

• • Greenway
  • 
  • • Joined 25 Aug, 2012
    • 
    • 1 topics • 3 posts
  • 1

  • 1 Mar, 2015
  • Quote

  Hi,

  I have been working with Construct for some time and I'm now lost into tasks getting too difficult for me.

  I can make an array from an sql database, and it opens a lot of possibilities, but I'm stuck when it comes to update the database.

  Here is the php coding I use to send data to MySQL :

  if(isset($_GET['name']) && isset($_GET['score'])){

  $name = strip_tags(mysql_real_escape_string($_GET['name']));

  $score = strip_tags(mysql_real_escape_string($_GET['score']));

  $sql = mysql_query("INSERT INTO `$db`.`scores` (`id`,`name`,`score`) VALUES ('','$name','$score');");

  With the Ajax object, we can call an URL like "....?name=NAME_HERE&score=1337" and then make a new line in the Database.

  My question is, how to edit/update a particular item. For example if I use this method to make a profile and the player wants to change a line of it...

  The index of my database is "id" which is auto_increment. I'm not sure if it helps or not.

  I have been watching dozens of tutorials but nothing is working for me. If you have any idea how this would be working I thank you in advance.

• Try Construct 3

  Develop games in your browser. Powerful, performant & highly capable.

  Try Now Construct 3 users don't see these ads
• • Greenway
  • 
  • • Joined 25 Aug, 2012
    • 
    • 1 topics • 3 posts
  • 1

  • 25 Aug, 2012
  • Quote

  Looks awesome. But the problem in that kind of indie mmo shooter is always the fluidity getting low when the server is surcharged.