10 {{ upvoteCount | shortNum }}
10 {{ upvoteCount | shortNum }}

PHP/MySQL?

by Jimi b
8 replies
im looking to have a script created for a concept a partners and i came up with. But before i post the job on elance i need to know what programming language would be required to create this script. this is what i want the script to do
a user go to my mobile site, upload a photo into a database on my server
then the pic along with previously stored info within the database are combined.
when they are combined the script will automatically create a qr code for that pic and its info. when the qr is scanned the pic and info will be perfectly formated
the qr code can be generated using google charts api. Hopefully this generic example is enough to suggest what language skills are needed. Any advise or knowledge on this matter is highly appreciated.
#php or mysql #progamming
  • Profile picture of the author Terry Crim
    The server side can be done in PHP for you project. How much server load do you think the project will experience? How much traffic are you planning to send and in what time frame? I am asking what the top end of visitors you think your site will experience in any given day / hour?

    If you plan on having a large traffic site you may want to look at using PosgresSQL vs MySQL as the database. MySQL is great for smaller sites with less than a million visitors but when you start getting into the higher numbers there can be issues. I am talking more hourly than daily or weekly traffic.

    You want to look at peak numbers in a given hour and minute by minute basis on a similar project to guesstimate what your loads maybe and even then it is just a guesstimate but you can look at hardware specs and hosting requirements, bandwidth etc from those numbers.

    If you don't know then you need to figure out how much marketing and promotion you are going to be doing and where the traffic may come from.

    I assume this is a site with existing traffic as you mentioned your mobile site. Look at what you are currently using for database platform and the traffic you are currently now getting, if things seem to be going well then use what you are using. I assume it is MySQL.

    Depends on the features you want the script to have but you can easily do this with php and jquery mobile.
    {{ DiscussionBoard.errors[6546053].message }}
    • Profile picture of the author Jimi b
      Originally Posted by Terry Crim View Post

      The server side can be done in PHP for you project. How much server load do you think the project will experience? How much traffic are you planning to send and in what time frame? I am asking what the top end of visitors you think your site will experience in any given day / hour?
      Thanks for the reply Terry
      Between 650k-1.5mil mobile visitors per month with close to 320k+ in one day. by no means am i doing these numbers now but when the system is into place and marketing efforts ramped up those are the projected numbers.

      In regards to jquery mobile, what function would it serve since the php handles the server side?
      your insight is very helpful, thanks.
      {{ DiscussionBoard.errors[6556870].message }}
  • Profile picture of the author KirkMcD
    Originally Posted by Jimi b View Post

    when the qr is scanned the pic and info will be perfectly formated
    What do you mean "perfectly formatted?"
    {{ DiscussionBoard.errors[6548366].message }}
  • Profile picture of the author Jimi b
    After the content is programmed into the qr, the qr is scanned. When the script search the database to retrieve the content that is programmed into the qr code (pic,text,audio,video), it returns the selected content and present it formatted into the desing and theme of the page.

    hope im making sense.
    thanks
    {{ DiscussionBoard.errors[6556763].message }}
  • Profile picture of the author antac
    Banned
    PHP is probably the most popular scripting language on the web. It is used to enhance web pages. With PHP, you can do things like create username and password login pages.


    MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System.
    {{ DiscussionBoard.errors[6657999].message }}
  • Profile picture of the author mmrumii
    PHP is the most popular programming language and By using this language we can create registration forms, login forms etc. & MySQL is the best Database Management system.
    I used those for my site.
    Signature
    Blog about Content Locking and CPA
    {{ DiscussionBoard.errors[6674368].message }}
  • Profile picture of the author 26medias
    To take a picture from a mobile and upload it, you'll need an application. Depending on the platform, it can be written in Object C, Java, Air/AS3...
    That's for the front-end.
    On the back-end, PHP/SQL is good enough.
    Signature
    600+ graphics and 200+ html templates for your WSO and sales pages!
    {{ DiscussionBoard.errors[6676065].message }}
  • Profile picture of the author xxmm94
    you can use php or asp.net
    both will do great

    or you can go for ready scripts
    {{ DiscussionBoard.errors[6676208].message }}

Trending Topics