After I’ve determine which interfaces are active on my computer(s), I can use this script to report back the IP address of said interface.
# input String ("en0")
# output String IP
function get_network_interface_ip($interface) {
@exec('/usr/sbin/ipconfig getifaddr '. $interface, $retval);
return $retval[0];
}// end get_network_iterface_ip
echo get_network_interface_ip($interface);
I use this script, after I determine what available interfaces the computer has, to report which interfaces are active.
# input String ("en0")
# output "NULL or "Active"
function check_interface_activity($interface){
@exec('ifconfig| awk \'/flags=|media|inet / {if (substr($2, 1, 6) == "flags=") printf("\n%s ", $1);
else if ($1 == "inet") printf("%s ", $2);
else if ($1 == "media:") printf(substr($0, 9))}\' | awk \'$1 ~ /^'.$interface.'/\' | awk \'{print $7}\'',$retval);
return $retval[0];
} // end check_interface
echo check_interface($interface);
I use this script to gather all Ethernet based network activity to determine which network port is active and then determine what the hardware address and IP address are.
# input NONE
# output String ("en0, en1")
function get_all_active_network_interfaces() {
$inclusion = array(en0,en1);
@exec('/sbin/ifconfig -lu', $retval);
$interfaces = explode(" ",$retval[0]);
$ret=NULL;
foreach($interfaces as $interface){
if (in_array($interface,$inclusion)){
$ret.=$interface ." \n \r";
} // end if
}// end foreach
return $ret;
} // end get_all_active_network_interfaces
echo get_all_active_network_interfaces();
This script is similar to the above script, but doesn’t include the constraints of the inclusion list.
# input NONE
# output String ("en0, en1, etc")
function get_all_active_network_interfaces() {
@exec('/sbin/ifconfig -lu', $retval);
$interfaces = explode(" ",$retval[0]);
$ret=NULL;
foreach($interfaces as $interface){
$ret .= $interface ." \n \r";
}// end foreach
return $ret;
} // end get_all_active_network_interfaces
echo get_all_active_network_interfaces();
Posted by dmccoy | Posted in Code, MySQL, PHP | Posted on 18-07-2009
This is how I normally link PHP to my MySQL servers. I use this code normally for my shell scripting, but it also works for websites.
$mysql_server = "SERVER_ADDRESS";
$mysql_user = "SERVER_USER";
$mysql_password = "SERVER_PASSWORD";
$mysql_database = 'SERVER_DATABASE';
$mysql_table = 'SERVER_TABLE';
$mysql_connection = @mysql_connect($mysql_server,$mysql_user,$mysql_password);
if (!$mysql_connection)
DIE ('ERROR 10: No Connection to '.$mysql_server.' '. mysql_error() ."\n");
$mysql_database_connection = @mysql_select_db($mysql_database,$mysql_connection);
if (!$mysql_database_connection)
DIE ('ERROR 30 : Could not select database '. $mysql_database .' '. mysql_error() ."\n");
echo "MySQL : Connection Active \n";