trq

A database is a completely separate thing to a web application. You sound like your confusing them as the same thing. You have a web application that interfaces to a database. If you want to run that application locally you will need a web server, a database server, the code for the web application, and the data from the database. xampp and the like provide a simple one click install and configure of the web server and database server components. Keep in mind though that once you are running this application locally users won't be able to access it. Nor will is be in any way integrated with the solution you already have online. It really sounds to me like your going to need a developer to handle this. While you may be able to find some basic instruction and guidance online, you really need someone to actually look at the actual problem and find the best solution. What you are trying to do definitely does not sound ideal.

Updating your hosting sounds like the more logical approach. Sure, you can make a database back and then remove old records from your current database, but that really doesn't seem at all logical.

I don't see whats funny. If you need help, ask a question / describe your problem. Simply stating what you want does little to describe where you are stuck.

Notice that code is normally syntax highlighted here? That's because code needs to be wrapped in code tags. The <> in the editor menu. Now, besides that, you have posted too much none relevant code and no question. Until you fix your post, no one will want to help you.

As is clearly stated in the shebang, that code is Perl not Bash.

Awesome, I'm getting some replies. I should probably mention that I struggled to get my list of 10, but I should also mention there are a bunch of cli type utils that I left out. These are things I use every day and would be pretty lost without. bash, python (most of our infrastructure uses it), grep, composer, gitflow, wget, ssh, irssi, ttytter.

You have that backward. Server side processing cannot change what has already been sent to the browser. JavaScript on the other hand is very commonly used to manipulate the DOM.

Following on from my reply to ballhogjoni's What do you think thread. I thought I'd ask the question - what development tools can you not work without? Or at least, what is your top 10 list of development tools? For me (in no particular order); 1 ) MacBookPro (and no, I don't have the retina one). Being a long term Linux user it has taken me a while to admit to, but now days, I love my Mac. It's an awesome desktop machine yet still has all the power of unix underneath including my old faithful Bash shell. 2 ) Vim. I have been using vim for many years now and wont use anything else. It's light, customisable, on every machine I work with. 3 ) Git. Git has version control pretty well spot on in my opinion. It does what it's meant to and stays out of my way, but also has lots of cool tricks that make development so much easier. 4 ) Github. While I'm not someone lucky enough to use Github on a daily basis, I do have a few of my own projects hosted there. It's an awesome resource for developers and has IMO improved the lay of the land in regards to FOSS software dramatically over the last few years. 5 ) HomeBrew. Coming from Linux to Mac, there are obviously a bunch of tools that would otherwise not be easy to install / update. brew makes this easy. 6 ) Vagrant. With most of my development work still taking place within a Linux environment. Vagrant makes it easy to setup these environments in a predictable mannor. 7 ) tmux. I simply cannot work without this awesome tool. 8 ) Jira. We have been using this at work now for about the last 12 months. With a good workflow and process in place this has been bar far the best issue tracking I have used. 9 ) Funtoo. My all time favourite Linux distribution. Super customisable and light weight. Not exactly what I would call user friendly however, but thats cool - it's a great learning tool as well. We maintain around 1200 servers where I work, all of which until recently were FreeBSD. Around 12 months ago however I was put in charge of building a Linux based system for us to use. I chose Funtoo as our base and don't have any regrets at all. An awesome OS that has been great fun to work with. 10 ) Puppet. While I have only recently started really using puppet for more than just a few simple tasks this tool is really starting to shine as a part of our day to day process at work. I hail it.

You forgot to ask a question.

I'd start by removing the error suppressor from your call to mail and see if your getting any error.

Can we see the output of: show create table tablenameDon't forget to tell use the name of the columns that are giving you grief.

These are two of the things I would have asked about during the interview process. If you didn't ask, while I believe you can make suggestions or even ask for the things that you want, you've made your own bed, your going to have to lie in it. I need my development environment to be enjoyable & customisable. I use vim on *nix and wont touch Windows machines ever. I need decent version control (either svn, git or mecurial) and a clear process around it. I also usually inquire about any ticketing systems used and also how that process works. I've worked for places that couldn't answer some of these questions properly but were excited that I had asked. They were happy to have me lead the way in terms or processes around version control and ticketing systems. This is something I personally enjoy. If I were at an interview and asked these question and they couldn't be answered or I could tell the company didn't care, that would be it for me. I turned down two jobs last year because they wouldn't have accepted having a developer using a Linux box, now did they use version control at all.

See: http://php.net/manual/en/language.operators.string.php That code already has issues as well unless you have defined the days of the week as constants.

You forgot to ask a question. You also forgot the fact that no one here cares how urgent your project is. If you want help fast, hire a programmer, otherwise ask your question and wait in line.

This resonates with me more than anything else. http://blog.sanctum.geek.nz/series/unix-as-ide/

My main motivation for working in vim is the fact that we do allot of remote stuff via ssh on client machines at work. So, now I can use the same editor under all circumstances. Even when I work from home, it's so much easier to just connect to the vps, ssh in and open vim in a terminal. I don;t have to worry about the overhead of a Desktop.

Have you tried an IDE? I used to think a simple text editor was all I needed too, but then I tried an IDE. The only time I use a regular text editor now is just for real quick edits, or stuff that I don't want to make into a project in my IDE. IDE's tend to get in my way. All I use is vim with a few plugins: https://github.com/tpope/vim-pathogen https://github.com/tpope/vim-fugitive https://github.com/tpope/vim-unimpaired https://github.com/vim-scripts/taglist.vim https://github.com/vim-scripts/sessionman.vim https://github.com/vim-scripts/bufexplorer.zip https://github.com/tpope/vim-surround https://github.com/vim-scripts/FuzzyFinder

I'm a massive vim fan so don't really have much of an opinion when it comes to IDE's.

That's because MS sux balls.

Hmmm, I smell spam.

There is no definitive answer, just opinion. Often the one that is well suited to your style of development and specific project requirements will be the best one to use.

I used to use dynamically loading js, but it ended up being allot more efficient to put all js into one file and the minify it. Its the actual http requests to multiple files that hurts more than size. Of course it would also depend on what sizes where talking about. Loading a 50k-80k file just to use one function etc etc.

Have you checked out some of the editors mentioned in this thread?

This board is here for questions directly relating to already existing Third Party code. It is NOT a code repository or the place to post requests looking for specific scripts. If you can't find the script you are looking for on Google, you either don't know how to use Google or the specific script does not exist. DO NOT request help with searching.

I'm not sure how that would be achieved through php. The rule is that you use a before words that start with a consonant sound and an before words that start with a vowel sound.