My understanding is that the PHP mysqli extension will be removed in a future version of PHP.
I highly recommend that you use PDO for any PHP project from now on. PDO allows bound parameters (improved security) and it makes it easier to connect to different database systems.
I was writing PHP apps in 2008 with PDO and it has served me well.
EDIT: All my apps here on CodeCanyon use PDO.
Yay 100+ sales of one of my apps! Also yay to a new version just released.
The iPod Touch would work great for this. Same screen and browser.
Why do you want an iPhone without a sim? You could get an iPod Touch for cheaper, the new ones look cool.
The iPhone can connect to the Internet via wifi without needing a SIM card. I had an old iPhone around the house doing this.
The phone might need to be activated first though.
I updated 5 items yesterday and got an approval email for each. So it is working for me.
No easy way.
Are you talking about HESK (based on the SQL query you have posted I think you are)?
Please be aware of the following in the license agreement:
“Using this code, in part or full, to create derivate work, new scripts or products is expressly forbidden.”
If not then good luck! Providing support for a ticketing system can be a lot of work.
There are already a lot of good ticket systems on codecanyon.
It might be easier just to use an existing one and make some minor changes to suit your needs?
I have a very similar system that I wrote (and is available to download on codecanyon).
The system contains a number of different sections.
User Registration + Licensing
The system has an open user registration system. Users with an existing item purchase code can register to gain access to the support portal.
As I have a number of different plugins I have setup a white list of products that allow users to register with; i.e you must have purchased a full application and not just a plugin to be allowed to register.
Once users have registered they can add multiple license keys to their account, allowing them to track the number and type of licenses that they own.
I can view all the users and the licenses that they own.
Forums + Articles
After a user has registered they get access to a forum where they can chat about the product. This is also where I post some free plugins (basically an incentive to sign up).
This is great for general chat that doesn’t require direct support and it keeps my codecanyon pages clear for pre-sale questions.
There is also a Knowledge Base section where I post commonly asked questions (this is also public: http://portal.dalegroup.net/public/kb/)
Here is my the core of my offering, a full featured ticket system that allows users to email us directly. Similar to your system users can staff can reply via email and it gets correctly stored and forwarded.
The ticketing system is a great way to send users hotfixes or patches for their applications. They can then login and download the files.
I have also setup a push notifications system with pushover.net that will push new tickets to my iPhone.
Over all it is very cool and is so much easier to manage than users sending emails directly to me!
I really like the little community of users it has gathered. It allows users to better interact with each other.
I have a wide range of features that I want to add.Some of them include:
- Application Stats (allow users to link their applications to the portal and get some specific stats compared to others with the same app).
- Download the latest versions of my apps directly from the site
- More free plugins
- Voting on new features etc
Here is a screenshot of the graphs I want to use for stats: