SitePoint Sponsor

User Tag List

Results 1 to 18 of 18
  1. #1
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb Windows Desktop Application to communicate with website

    Hello

    I know PHP , HTML and CSS and some Javascript,

    Could someone guide me to the proper path to achieve the following:

    1). to get a small notification window appear above Taskbar (just like New Email in Thunderbird Ballon).

    E.g. Just like this Tray Popup Utility







    2). To create a full application which can add, delete, update etc the products without going through the browser.


    For e.g here is a similar Windows Application built in Delphi for Oscommerce ecommerce script. This is what I exactly want to achieve.

    Screenshots:
    Source : http://www.mariovaldez.net/software/...creenshots.php
















    Is PHP GTK2 powerful enough compared to Python's wxPython ?

    I was wondering if it would be better to start learning Python so that I may be able to build Windows App through wxPython.

    Or should i start with PHP GTK2 ?

    What about learning Windows Presentation Foundation (WPF) ?


    P.S. I do not want to learn Java or C++
    .
    Last edited by Farrukh; Apr 23, 2009 at 03:33. Reason: Summary change

  2. #2
    Twitter: @AnthonySterling silver trophy AnthonySterling's Avatar
    Join Date
    Apr 2008
    Location
    North-East, UK.
    Posts
    6,111
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Could you not just build an API (SOAP, REST) on top of your web application? Just use a transportable format like XML...
    @AnthonySterling: I'm a PHP developer, a consultant for oopnorth.com and the organiser of @phpne, a PHP User Group covering the North-East of England.

  3. #3
    SitePoint Wizard
    Join Date
    Mar 2008
    Posts
    1,149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Don't write your application in PHP because PHP isn't built for the desktop (it lacks threading, etc.). If you're going to use a dynamic language, then Python is the way to go.

    If you want to use WPF, then you will have to use IronPython (whick works with .NET). That will make your application unportable though.

  4. #4
    SitePoint Zealot
    Join Date
    Apr 2009
    Location
    South Florida
    Posts
    187
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you planning to update connect on your website from a Desktop application, i think easiest way to do is connect to your MySQL database from desktop application. But you have to be careful with the security, you may want to create a separate user account in MySQL giving limited access to few tables for editing.

  5. #5
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by lphy View Post
    If you planning to update connect on your website from a Desktop application, i think easiest way to do is connect to your MySQL database from desktop application. But you have to be careful with the security, you may want to create a separate user account in MySQL giving limited access to few tables for editing.

    Yes, this seems like a plausible solution. Are are any guides/tutorials on achieving this.

    I am also leaning towards learning Python and then wxPython for desktop application.

    What about Visual C# ?

  6. #6
    SitePoint Zealot
    Join Date
    Apr 2009
    Location
    South Florida
    Posts
    187
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes you can easily create your desktop application using Visual Studio (C#)
    go to MySQL website and get the MySQL .Net data provider. Using that you can easily connect to your MySQL database. Ones you made the connection, you can use all the built in functions in .Net and Visual studio to develop your application.

    If you want to do some testing on your MySQL database to check connection or build a connection string you can use this tool
    http://www.digitalcoding.com/free-so...ng-Tester.html

  7. #7
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by lphy View Post
    Yes you can easily create your desktop application using Visual Studio (C#)
    go to MySQL website and get the MySQL .Net data provider. Using that you can easily connect to your MySQL database. Ones you made the connection, you can use all the built in functions in .Net and Visual studio to develop your application.

    If you want to do some testing on your MySQL database to check connection or build a connection string you can use this tool
    http://www.digitalcoding.com/free-so...ng-Tester.html

    Thanks for the link.

    So it comes down to either learning Python or C#.

    Which would be more comfortable coming with a background from PHP?

    Also, are there any inherent advantages of C# over Python ?

  8. #8
    SitePoint Zealot
    Join Date
    Apr 2009
    Location
    South Florida
    Posts
    187
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I never worked with Python before, I been working on both PHP and C#, if you using c# with visual studio its very easy

  9. #9
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by lphy View Post
    I never worked with Python before, I been working on both PHP and C#, if you using c# with visual studio its very easy
    Can you recommend any Books, learning aid for complete beginners in C#.

    I am only interested in developing GUI Applications.

  10. #10
    SitePoint Wizard
    Join Date
    Mar 2008
    Posts
    1,149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    They're both managed languages, so you don't have to deal with memory and such, so it shouldn't be too hard with either languages. Java is in the same boat too, although you don't want to use that.

    C# is closer to Java than Python is, however.

    Python is a much more dynamic language though, if that's your thing.

    By the way, I would personally access the database through some script you write in PHP or through some custom server you may write to run on the server. Accessing the database directly is a bad idea from the beginning because with some packet sniffing and/or disassembling, a malicious user could easily bypass any checks and logging you do on the client. Of course, if the permission support of your DBMS is granular enough for your needs, then it's not an issue.

  11. #11
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by sk89q View Post
    They're both managed languages, so you don't have to deal with memory and such, so it shouldn't be too hard with either languages. Java is in the same boat too, although you don't want to use that.

    C# is closer to Java than Python is, however.

    Python is a much more dynamic language though, if that's your thing.
    I have nothing against Java, its a great language. But i don't like its verbosity.

    whereas Python is very concise

    So i have to decide between C# and Python.

  12. #12
    SitePoint Wizard
    Join Date
    Mar 2008
    Posts
    1,149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    C# may be too verbose for you too then. C# is Microsoft's attempt at taking away Java's market share and it's very much like Java.

  13. #13
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by sk89q View Post
    C# may be too verbose for you too then. C# is Microsoft's attempt at taking away Java's market share and it's very much like Java.

    So that leaves me with Python. Any other suggestions.

  14. #14
    SitePoint Wizard
    Join Date
    Mar 2008
    Posts
    1,149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Uh, I'd look into some examples of both Python and C# code though. Don't take my word for it. It might suit you after all.

  15. #15
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I've done this quite a few times before now. I've done it in C# and Java, both were simple to make. C# and Java are similar, but that's no reason to dismiss C# because of your thoughts about Java's faults.

    I would recommend against sending commands to PHP from this application, and letting PHP do the work. You'd be much better off giving your application direct access to the database engine. I've been down both routes and it's definitely faster.

    C# is easy to grasp from a PHP developer's point of view, but you can't just learn is as you use it in a big project.

    Whatever path you go down, you really should have a strong knowledge of the language before you decide to build a real program with it.
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  16. #16
    SitePoint Evangelist
    Join Date
    Jun 2006
    Location
    Wigan, Lancashire. UK
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you do want a web-based application running on a desktop, you could always look at Adobe's AIR/Flex
    ---
    Development Projects:
    PHPExcel
    PHPPowerPoint

  17. #17
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @arkinstall thanks for your input.

    @Mark Baker, thank i have looked into it as well.

    I have decided to finally go ahead with Python followed by PyQt for building GUIs.

  18. #18
    SitePoint Wizard REMIYA's Avatar
    Join Date
    May 2005
    Posts
    1,351
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Java is worth considering in this situation.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •