jrough;10990347 wrote:I don't need the database abstraction I am only using MySQL so I would think I need mysqli?
If that were indeed the case and you know that isn't going to change in the forseeable future, then yes, I would personally say using [man]MySQLi[/man] makes more sense. Then again, if you have (or want) more experience with [man]PDO[/man], then by all means go for it. Neither option is "right" or "wrong," after all.
jrough;10990347 wrote:With mysqli you can use multi queries.
Eh... I suppose you can, yes, but how often do you actually need to do that? Plus, I wouldn't be surprised if the PDO driver couldn't do this as well.
jrough;10990347 wrote:This is only an internal tool but there is a risk of loosing proprietary info so I like the prepared queries in PDO.
Okay, so two questions:
How does the use (or non-use) of prepared statements affect in any way "[losing] proprietary info" ?
Why don't you consider MySQLi here as well (since it can do prepared statements just as well as PDO)?
jrough;10990347 wrote:Should I attempt to use Jira widgets
What's a Jira widget? 😉
jrough;10990347 wrote:I really don't know anything about Jira except it is used for this but I assume JQuery UI is similar ?
Uh... unless we're talking about something different, the Jira software package I used was an entire software development web suite/application used for things like project management, collaboration, bug tracking, etc. etc. On the other hand, jQuery is an AJAX framework.
In other words, the two have about as much in common as a plastic spork has in common with a dinosaur. Granted, I'd still say the question is one only you can answer. Do both avenues provide the means to accomplish your goal? If so, then most everything else is just subjective opinion (which might as well be your own since this is your project and not ours, after all).