So i just discovered this issue with MySQL full text search… Full text searches only return anything, if the number of results is less than 50% of the total table size! So i have been racking my brain for a few days over this issue. I have a database with the letters “wow” in it [...]
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, [...]
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 [...]
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.
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
