WTF *Nix

Just another *nix Blog

Archive for the ‘MySQL’ Category

PHP MySQL Functions

Apr-23-2010 By WTF *Nix

MySQL Functions for PHP

mysql_affected_rows — Get number of affected rows in previous MySQL operation

mysql_client_encoding — Returns the name of the character set

mysql_close — Close MySQL connection

mysql_connect — Open a connection to a MySQL Server

mysql_create_db — Create a MySQL database

mysql_data_seek — Move internal result pointer

mysql_db_name — Get result data

mysql_db_query — Send a MySQL query

mysql_drop_db — Drop (delete) a MySQL database

mysql_errno — Returns the numerical value of the error message from previous MySQL operation

mysql_error — Returns the text of the error message from previous MySQL operation

mysql_escape_string — Escapes a string for use in a mysql_query

mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both

mysql_fetch_assoc — Fetch a result row as an associative array

mysql_fetch_field — Get column information from a result and return as an object

mysql_fetch_lengths — Get the length of each output in a result

mysql_fetch_object — Fetch a result row as an object

mysql_fetch_row — Get a result row as an enumerated array

mysql_field_flags — Get the flags associated with the specified field in a result

mysql_field_len — Returns the length of the specified field

mysql_field_name — Get the name of the specified field in a result

mysql_field_seek — Set result pointer to a specified field offset

mysql_field_table — Get name of the table the specified field is in

mysql_field_type — Get the type of the specified field in a result

mysql_free_result — Free result memory

mysql_get_client_info — Get MySQL client info

mysql_get_host_info — Get MySQL host info

mysql_get_proto_info — Get MySQL protocol info

mysql_get_server_info — Get MySQL server info

mysql_info — Get information about the most recent query

mysql_insert_id — Get the ID generated in the last query

mysql_list_dbs — List databases available on a MySQL server

mysql_list_fields — List MySQL table fields

mysql_list_processes — List MySQL processes

mysql_list_tables — List tables in a MySQL database

mysql_num_fields — Get number of fields in result

mysql_num_rows — Get number of rows in result

mysql_pconnect — Open a persistent connection to a MySQL server

mysql_ping — Ping a server connection or reconnect if there is no connection

mysql_query — Send a MySQL query

mysql_real_escape_string — Escapes special characters in a string for use in a SQL statement

mysql_result — Get result data

mysql_select_db — Select a MySQL database

mysql_set_charset — Sets the client character set

mysql_stat — Get current system status

mysql_tablename — Get table name of field

mysql_thread_id — Return the current thread ID

mysql_unbuffered_query — Send an SQL query to MySQL without fetching and buffering the result rows.

Share and Enjoy:
  • Google Bookmarks
  • MySpace
  • Facebook
  • StumbleUpon
  • Print
  • email
  • Digg

I’m starting to see a trend here, seems their MW on MyCrackedSpace (MySpace) is running way smoother than it is on Crackbook… (Facebook)

The trend can be found here in what I’m talking about in the times for a Scheduled Maintenance on both:

30 minutes for MySpace

3 hours for Facebook

This goes to show you, this is a bit out of whack on FB for FB has been having some serious @#$ked up issues with the Developer API, I just fixed an app for a client of mine last week to counter Facebook’s developer HAVOC. (freaking’ nightmare)

Long story short, it seems FB is putting down some pressure on all the larger apps out there for security and privacy issues. Let’s just hope and pray that Zynga can pull out of this one, because they are facing lots of obstacles here which seems to be broken on the FB side of things…

Also we all know that Zynga’s servers responses are slow, which is one thing on Zynga’s end, which I can understand when you grow so fast and no more room to grow on… You scurry and make mistakes as you are scurrying… WITHOUT Q&A and a proper testing team in place, you will encounter bugs galore!!!

All the power to Zynga on trying to fix their issues, my hats off to them once they do! So I take back for the remarks against Zynga on this issue they are facing. It’s more than you can even write in “Layman Terms.”

So WTF get’r done!!!!

Share and Enjoy:
  • Google Bookmarks
  • MySpace
  • Facebook
  • StumbleUpon
  • Print
  • email
  • Digg

ClientExec MAIN Tab Manual

May-8-2009 By WTF *Nix

Well, well, well, I guess it’s time to release yet another helping hand to the Newedge Community!!! WOOHOO they say? Heck no! I say WTF Get ‘r Done!

Here you have a release of a full fledged “by the book” (HAHA NOT REALLY) manual by I myself from the Newedge Community Forums epctechno

I would like you to know, I’m not wanting you to read this off my website, I have uploaded the the PDF which is 9.1+ MB BIG in low compression in zip, tar.gz, .rar, and .7z here:

zip

tar.gz

rar

7z

You pick the format to download, it’s up to you. :)

Hope you enjoy this and if you find it in your heart to donate, please do! Took sometime on putting all of this together in a two-day span of time.


Share and Enjoy:
  • Google Bookmarks
  • MySpace
  • Facebook
  • StumbleUpon
  • Print
  • email
  • Digg

FreeBSD Guides and Tips

Jan-7-2009 By clarkee

Hello Everybody,

I’m new here so I thought I’d tell you all about my main ‘project’ documenting my experience with FreeBSD and how to use FreeBSD for common tasks!

I work in a software development company and from time to time we need servers for many tasks like blogging, wiki’ing, version control, ftp, mail, application servers etc.  As I perform projects I like to write simple how-to type instructions so anybody else can follow my steps :)

Check it out at http://www.freebsdguy.co.uk and feel free to leave some comments!

Share and Enjoy:
  • Google Bookmarks
  • MySpace
  • Facebook
  • StumbleUpon
  • Print
  • email
  • Digg