I am trying to use Netbeans PHP and have a LOCAL copy of WordPress with a remote mysql database.

This was an obscure error which the following php revealed some hints.

[php]

<?php
$db = mysql_connect(‘1.2.3.4’, ‘username’, ‘password’);
if (!$db) echo "connection failed";
else echo "connection succeeded";

echo phpinfo(); ?>

[/php]

Note that the @ is NOT in front of the mysql_connect statement – this means you will see all the errors generated when something goes wrong. What it said did not fix the issue. I do NOT have control over this mySQL install (cannot see or set things in the user table)

It did not like the old password created by the script that made the WordPress installation. So to solve this, after an hour, I finally came acro

Then, our good friends at stack overflow had suggested this ….

[code]
<pre><code>SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD(‘[your password]’);</code></pre>
[/code]

This fixed it.

However, he continues with (I didn’t try this)

[php]<code>define(‘CLIENT_LONG_PASSWORD’, 1);</code>
<pre><em id="__mceDel"><code>mysql_connect(‘[your server]’, ‘[your username]’, ‘[your password]’, false, CLIENT_LONG_PASSWORD);
[/php]

I am now a fan of WordPress. It is not that it is the best for myself or my customers but it is the penetration into the market and how well it gets along with its friends like Google, Facebook and so many other web services. There are more plugins that do the same thing, there is surely one out there that meet your needs.

Integrating and customizing themes is quite easy once you understand the file structure as well. Overall it is effective and therefore inexpensive to have running. I first learned it from a good friend who shared what he knew at geekinc.ca which rocketed me from an intense Joomla knowledge into the next wave of content management systems. As I use it, my customers ask questions etc., I narrowed it down to this list.

Standard Plugins I would recommend any site to employ would be…

• Add link to Facebook
• Captcha seems to work quite well although I made some changes so it uses images – the company that made it, doesn’t want to update it, so I only updated it so far. When the spam continues, I will finish it. Seems to have stopped spam so if you want it, it works for now.
• [optional] My Twitter Widget does what it claims – puts your tweets on the side of your website. No I am not using it because I don’t tweet (yet). With a little CSS magic it cleans up just the way you require.
• [depreciated in my use – see Hupso] WP to Twitter Widget works well
• Hupso Share Buttons for Twitter, Facebook & Google+  I am using this instead of WP to Twitter because I can just click these buttons to self-tweet and self-post to facebook AND MUCH MORE! These are all the little icons under my posts
• Akismet – you get what you pay for – this one works well to stop spam. I am not using it because I am too cheap – but it does what it claims for my customers
• Exclude Pages from Navigation
• FD Feedburner Plugin
• Google Analytics for WordPress
• Google XML Sitemaps
• [optional] Login with Ajax
• [optional] podPress
• WordPress SEO– the one by Yoast
• [optional] Contact Us This one is good and very configurable to make a contact us form. I am using Dropifi as it is free to set up an account.
• [optional] Dropifi – see the ContactUs flyout on my site … enough said.
• Image Paste – you can just simply “paste” images in – too cool. The only drawback is that the images are embedded in the blog most – not the media directory. If your editor is having a bad day. .. not good – no more pics
• [optional for coding geeks] SyntaxHighlighter Evolved
• Insert Html Snippet just install this – why? Because if you have paypal buttons or any other HTML that needs to be “just-so” then your text editor will not format it incorrectly since it is an abstraction. You will need it at some point, so just insert it and learn how to use it.
• [optional] Smart Youtube If you have a youtube account or post videos – just paste your link and change http to httpv and … by magic – the video just is there and looks great. How simple is that?

One customer wanted a booking system that allowed 3 bookings at most at one time with a 15 minute buffer in between. So was born www.bookmedanno.com (you have to be old to get that joke). Coming is the ability to book and pay for a booking – but that aside …

The big challenge was all the time synchronizing and ability to recursively see all bookings overlapping and then calculating anything with a depth of 3 or more layers – needed to be unavailable to book. Here is the website link – don’t finish a booking – as it is live unless you book something for playalatte.ca in Calgary, Alberta canada for a mom/dad and their tot.

• an SQL could not do this alone – first get all the information in a large time window (i.e. a day) via SQL
• using recursion, look at all the return results against each other
• calculate the depth at each start and stop of a booking and keep a tally array as you go along
• go through that tally array and make a new array of when you go in and out of 3 bookings or more
• THEN lastly make an inverse array of what is free and plot this visually and make a listing of bookings/times from this on pulldown lists

That was interesting and challenging – thought it might help someone else out on the web.

First, Mac are super cool because beneath that suave exterior is unix. A computer that is easy to use AND super powerful.

But not everything needs unix. Here is the coolest applescript to

1. load a random bingo card generator which I built in php (the unix part)
2. print the page
3. go to step 1 fifty times

[applescript]
set i to 1
repeat 20 times
tell application "Safari"
activate
tell application "System Events"
tell process "Safari"
keystroke "r" using command down
delay 1

keystroke return
end tell
end tell
–open location "http://www.apple.com"
end tell
delay 3
tell application "System Events"
tell process "Safari"
keystroke "p" using command down
delay 0.5
keystroke return
end tell
end tell
delay 4
say i
set i to i + 1
end repeat

[/applescript]