Auth_Type Configuration of phpmyadmin
Here is what I have found out about which strings are pulled by the configuration auth_type of phpmyadmin. Read the rest of this entry »
Archive for October, 2010
Connect to a Remote MySQL Server
Normally the default install of your MySQL only allows connection from same pc. Suppose the firewall is not an issue, MySQL should be able to accessed remotely, providing the privilege is given to a user from a special IP, otherwise you will get an error message like:
#1130 host ‘xxxx’ is not allowed to connect to this mysql server.
Read the rest of this entry »
Postback URL in WordPress Admin Page
As a wordpress plugin developer, it is very handy to provide an option page or admin page for your plugin, in essence this page is a standard php page, you can do postback to collect user data to save them in the database or for what ever reason. Read the rest of this entry »
Limit Linq Outer Join Left To One Row
When we use DefaultIfEmpty we are doing an outer join, and if there is no match on right table, there will be null for the right table fields in joined big table, we are happy about this, but if sometime the right table has multiple matches for one left table entry, this will eventually multiply left table entries in the final big table, so we do not want this, if there are more matches in right table we want it to limit to one. Read the rest of this entry »
Linq Join On Multiple Fields
We all know we can do a linq join query like this
from c in Customers join o in Orders on c.CustomerID equals o.CustomerID
If we have different companies and they all have their own customers, so we need to make join query based on two fields namely companyID and CustomerID Read the rest of this entry »
