These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

EVE API Newb
Author
Previous Topic Next Topic
Whitney Aubaris
AWOLGamers
#1 - 2017-01-04 23:20:57 UTC
I have looked high and low trying to figure out how to export my API into MySQL db and everything I have come across has been of vary little to no help.

Here is a link to my previous thread in the wrong section. EVE API Newb Post #4 is the most accurate as to what I am trying to do.

Any feedback would be greatly appreciated.
Whitney Aubaris
AWOLGamers
#2 - 2017-01-05 04:01:14 UTC
I've been trying to use the code from the following website but keep getting errors.
http://pastebin.com/gKnyq2K1


Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\xampp\htdocs\test.php:13 Stack trace: #0 C:\xampp\htdocs\test.php(13): SimpleXMLElement->__construct('') #1 {main} thrown in C:\xampp\htdocs\test.php on line 13
David Davaham
Deep Blue Logistics
#3 - 2017-01-05 04:39:46 UTC
I see you are working with PHP.

I strongly suggest looking into PhealNG.

Although a little dated, it works flawlessly with converting the XML API's XML Output into a PHP Array. From there you can manipulate the data as needed to store it in a datbase of your choosing.

Link

Developer of EVEmail
Whitney Aubaris
AWOLGamers
#4 - 2017-01-05 05:44:10 UTC
David Davaham wrote:
I see you are working with PHP.

I strongly suggest looking into PhealNG.

Although a little dated, it works flawlessly with converting the XML API's XML Output into a PHP Array. From there you can manipulate the data as needed to store it in a datbase of your choosing.

Link


I am going to look into it. :) Thank you.

If anyone else has more to bring to the feed I'm still up for more information, links, ideas, etc.
Whitney Aubaris
AWOLGamers
#5 - 2017-01-06 00:44:44 UTC
Okay so I'm a total newb when it comes to most code and that includes PhealNG. I don't have any how to use it even after going over the readme's more than once. I work best with PHP commands that work with a MySQL db as that is what I have been trying to teach my self.

Anymore input would be great!
Avrora Primogenitor
Pator Tech School
Minmatar Republic
#6 - 2017-01-07 11:13:25 UTC  |  Edited by: Avrora Primogenitor
PhealNG is a great tool and I have been using it for some years now. However I would not recommend using it. You will be building on a legacy library. PhealNG works with the XML API and the XML API will be discontinued within 12-15 months (Think the deadline was 18 months as of the launch of the ESI API?).

What I would recommend is looking into oAuth connections and authentication. Any oAuth bundle is able to communicate with the EVE SSO. Not sure what you're trying to create but you might want to look into a framework or CMS. You could try Symonfy2, Silex, Laravel, Bolt, Drupal8. Preferably you will work with Composer (your dependency manager).

EDIT (after reading post 4 in other thread):
So after reading what you're trying to accomplish I would recommend something like Symfony2, Composer and Doctrine ORM. Why? Because the Cookbook articles are very informative and easy to follow. If you follow the Symfony2 Cookbook you will be able to create the pages and objects you want. The database will be managed by the ORM so you will not have to worry about updating the database yourself.

Also learning a MVC framework is always nice since this concept comes back in different coding languages and frameworks.
Whitney Aubaris
AWOLGamers
#7 - 2017-01-07 14:07:38 UTC
Avrora Primogenitor wrote:
PhealNG is a great tool and I have been using it for some years now. However I would not recommend using it. You will be building on a legacy library. PhealNG works with the XML API and the XML API will be discontinued within 12-15 months (Think the deadline was 18 months as of the launch of the ESI API?).

What I would recommend is looking into oAuth connections and authentication. Any oAuth bundle is able to communicate with the EVE SSO. Not sure what you're trying to create but you might want to look into a framework or CMS. You could try Symonfy2, Silex, Laravel, Bolt, Drupal8. Preferably you will work with Composer (your dependency manager).

EDIT (after reading post 4 in other thread):
So after reading what you're trying to accomplish I would recommend something like Symfony2, Composer and Doctrine ORM. Why? Because the Cookbook articles are very informative and easy to follow. If you follow the Symfony2 Cookbook you will be able to create the pages and objects you want. The database will be managed by the ORM so you will not have to worry about updating the database yourself.

Also learning a MVC framework is always nice since this concept comes back in different coding languages and frameworks.

This looks promising, thank you vary much! Big smile