PHP/MySQL after 2010-005
After applying Security Update 2010-05, some users have reported PHP and MySQL problems, including an inability to connect to MySQL databases. Apple reports that the following procedure resolves the database connection issue:
In the Terminal type sudo nano /etc/php.ini (Terminal will ask you for your password)
Change: mysql.default_socket = to: mysql.default_socket = /tmp/mysql.sock
Press Ctrl-O, then Enter to [...]
Using remote_function
This wonderful built-in function is a great way to make easy Ajax calls. In this example I will show you how to use remote_function with the onClick call, and also within a JavaScript function.
First, lets make a checkbox called finish; this link will send the id of the item to the database to be updated. [...]
Database Class
The latest version 1.1.2 of the database class is now available for download! Check out the project page for info on how to use and download this class.
Grant access to your MySQL
One of the best tools i have ever used in my whole life for database management and design has to be Navicat. That application is just so useful and easy to get the hang of. So when i get a new server granting access is one of the first things i hit. How do i [...]
New Product: Winn Tracker
Something i have been working on for about three or four weeks now is something called “Winn Tracker”. This new product will have the ability to track page views, downloads and user information in your own custom application or website. Winn Tracker will allow you to make a call to the database to track info [...]
Create a database on the fly
In some recent work I needed to have databases created with a back end application. Once the database was created from this online application it was pre filled with tables and data from another script that ran right after the database was made. To create a database with PHP we first need to connect as [...]
Changing data in RoR
I needed to change some data that was not being submitted by my form. Your asking, what? Well say you have a form for account signups. The form has fields for: full name, email, and password. Now your database has columns for: full name, email, password, signupdate, and status. I needed to send the database [...]
Winn Framework
Currently in development is a framework that I have been using for some time. I am looking at making it cleaner and more usable for any project. I will be releasing the first version on this framework very shortly! With this version (0.10) you can make calls to get individual form elements or full login [...]
Authenticate a user from a MySQL database.
Authentication is important when building a web application, you don’t want others seeing information that does not belong to them. When you build an app that has “accounts” this is the login to your account. Just like going to Google and logging in to your account, it holds all your changes and settings.
To follow this [...]
Save time with Queries
In developing the June Project and JuneLite I came up with something that was saving me a lot of time. This php class is calling the queries for me all I need to do is write the guts of the query, and if updating provide the record id. This class can connect to your database [...]
From Our Blog
Twitter
