10-31-2011
You will find better help in a MySQL forum.
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
2. Shell Programming and Scripting
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Discussion started by: Danny_10
11 Replies
3. Shell Programming and Scripting
No help guys??? :(
Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...
so the first move would be, to access the mysql interface right? hence...
#! /usr/bin/ksh
echo "Job Begin: " `date`
... (1 Reply)
Discussion started by: 12yearold
1 Replies
4. Programming
I m devoloping a website which communicate with Linux server .
Whenever a page is loaded it runs one script on Linux server.
My problem is a simple commands like date , ls runs very smoothly. But whenever i execute big script.It wont display the output.
My knowledge of PHP is very less i m... (2 Replies)
Discussion started by: pinga123
2 Replies
5. Programming
Hello every one
i have question i want to build DATAbase using PHP as interface
i use shell to access to linux . i have in linux psql and SQLplus
i'll call all html files that has db tabels from shell directory.
what should to do before design php pages. can build the database sql design... (3 Replies)
Discussion started by: Scotch
3 Replies
6. Emergency UNIX and Linux Support
Hi,
I have two websites:
website1.com and website2.com
I didn't write either but have successfully moved all the files from website1.com to website2.com
I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Discussion started by: Astrocloud
15 Replies
7. Programming
Hello,
While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access... (2 Replies)
Discussion started by: AimyThomas
2 Replies
8. Web Development
Database Structure
Root Table
ID Root_ Node Level
1 A 0
2 B 1
3 C 1
Child Table
ID Left_Node Right_Node Root_Node Root_ID
1 B C A 1
... (1 Reply)
Discussion started by: Deepak Tiwari
1 Replies
LEARN ABOUT PHP
version_compare
VERSION_COMPARE(3) 1 VERSION_COMPARE(3)
version_compare - Compares two "PHP-standardized" version number strings
SYNOPSIS
mixed version_compare (string $version1, string $version2, [string $operator])
DESCRIPTION
version_compare(3) compares two "PHP-standardized" version number strings.
The function first replaces _, - and + with a dot . in the version strings and also inserts dots . before and after any non number so that
for example '4.3.2RC1' becomes '4.3.2.RC.1'. Then it compares the parts starting from left to right. If a part contains special version
strings these are handled in the following order: any string not found in this list < dev < alpha = a < beta = b < RC = rc < # < pl = p.
This way not only versions with different levels like '4.1' and '4.1.2' can be compared but also any PHP specific version containing devel-
opment state.
PARAMETERS
o $version1
- First version number.
o $version2
- Second version number.
o $operator
- If the third optional $operator argument is specified, test for a particular relationship. The possible operators are: <, lt,
<=, le, >, gt, >=, ge, ==, =, eq, !=, <>, ne respectively. This parameter is case-sensitive, values should be lowercase.
RETURN VALUES
By default, version_compare(3) returns -1 if the first version is lower than the second, 0 if they are equal, and 1 if the second is
lower.
When using the optional $operator argument, the function will return TRUE if the relationship is the one specified by the operator, FALSE
otherwise.
EXAMPLES
The examples below use the PHP_VERSION constant, because it contains the value of the PHP version that is executing the code.
Example #1
version_compare(3) examples
<?php
if (version_compare(PHP_VERSION, '6.0.0') >= 0) {
echo 'I am at least PHP version 6.0.0, my version: ' . PHP_VERSION . "
";
}
if (version_compare(PHP_VERSION, '5.3.0') >= 0) {
echo 'I am at least PHP version 5.3.0, my version: ' . PHP_VERSION . "
";
}
if (version_compare(PHP_VERSION, '5.0.0', '>=')) {
echo 'I am using PHP 5, my version: ' . PHP_VERSION . "
";
}
if (version_compare(PHP_VERSION, '5.0.0', '<')) {
echo 'I am using PHP 4, my version: ' . PHP_VERSION . "
";
}
?>
NOTES
Note
The PHP_VERSION constant holds current PHP version.
Note
Note that pre-release versions, such as 5.3.0-dev, are considered lower than their final release counterparts (like 5.3.0).
Note
Special version strings such as alpha and beta are case sensitive. Version strings from arbitrary sources that do not adhere to the
PHP standard may need to be lowercased via strtolower(3) before calling version_compare(3).
SEE ALSO
phpversion(3), php_uname(3), function_exists(3).
PHP Documentation Group VERSION_COMPARE(3)