PHP - What Do I Need To Know Before Changing Hosts, Domain Names?

Hello,

I am looking for a push in the right direction. I would like to be able to view a website that is duplicated on many servers by specifying the IP address. Similar to how one would use the hosts file.

I can do this using netcat
nc 1.2.3.4 80
Host: example.com
GET /contact-us.html
<CR><CR>

Can someone tell me how I would go about porting this to PHP? I would just like to set up a small page on my webserver where I can enter the domain and IP address and have the page displayed back to me.

Thanks Colin

Dear All,

I am having 2 different DB on 2 different hosts.

I am running MySQL Server on my local PC where the user is entering data in the tables. I have a website which has the identical DB on the web. I am able to connect to the database by using the codes on the server.

I want to update the server DB with the local system DB by running one update command. I get the error "-SELECT command denied to user 'localusername'@'localhost' for table 'pst_data'"

Given below is the code used for the process :

//connecting the remote system DB
$link = mysql_connect('IPAddress:3306', 'remoteusername', 'Password');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('remotedb', $link);
if (!$db_selected) {
    die ('Can\'t use Remote System DB: ' . mysql_error());
}

//connecting the local database on the webstite
$weblink = mysql_connect("localhost","localusername","password");
if (!$weblink) {
    die('Not connected : ' . mysql_error());
}
$webdb_selected = mysql_select_db('localwebdb', $weblink);
if (!$webdb_selected) {
    die ('Can\'t use WebServer Database : ' . mysql_error());
}

//query to fetch the records from remote ystem and insert into local website database
$upd_Query=mysql_query("INSERT INTO  localwebdb.`table` SELECT * FROM  remotedb.`table` where field=' some condition' ");
---------------------------------------------------

I have tested that I have connected the remote DB by running queries on the webserver.

Could anyone bail me out so that i can copy the DB from remote to local

Any help would be appreciated

Hello,

I'm attempting to write a PHP script to query WMI for an IP address of a host. The reason I'm doing this instead of getbyhostname is because NAT translations on the network can cause inaccurate results. The question is two-fold:

1) My Script is as follows
<?

$obj = new COM ( 'winmgmts://localhost/root/CIMV2' );
$wmi_network = $obj->ExecQuery("Select * From Win32_NetworkAdapterConfiguration");

foreach ( $wmi_network as $wmi_call )
{
    $ipaddr = $wmi_call->IPAddress;
    echo $ipaddr;
}
?>


I get the following error when running the script:
Quote

Catchable fatal error: Object of class variant could not be converted to string



2) How do I go about querying a remote host on the network with valid credentials?


Thank you

This topic has been moved to the corner of 3rd Avenue and mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=359430.0

I have two domains both running SSL. Let's call them old-domain and new-domain. old-domain is permanently redirecting traffic to new-domain. There are still a lot of links out there to old-domain with https://. If I were to remove SSL from old-domain but keep SSL on new-domain, I am betting that users will be getting some sort of certificate error. Right? Any way around that if I want to remove SSL from old-domain?

Hey , I'm looking for functions names from the GD directory.

1.function that open image.
2.function that getting pixel color.
3.function that changing pixel color.

thanks.

Hi,

I have db table that records the days (Sunday, Monday...) when the employee login to the system. Say that the employee logged in on Monday then Logged in on Wednesday so this means he was absent on Tuesday. I calculated the number of days to get the answer 2 (between Wednesday and Monday before logging in on Wednesday) how to get the name of the missing day "Tuesday"?

code:

$curdate = date("Y-m-d");
$currday = date('l');
$lastdate = $row['indate'];
$lastdayin = $row['lastdayin'];
					
if ($lastdate !=Null)
{
						
	$misseddates = strtotime($curdate) - strtotime($lastdate);
	$misseddates = $misseddates / 86400;
	echo $misseddates;
						
	$misseddays = strtotime($lastdayin) - strtotime($currday);
	$misseddays = $misseddays / 86400;
	echo $misseddays;
}

I tried to get the name of day in the last step but it only calculates 5 in numbers how to get the name. I want the answer to be "Tuesday" as of the example.

Thanks.

Hi guys,

I am currently stuck in a situation.

I have duplicated names in my form. View duplicated.jpg for a reference.

What exactly went wrong? Any help will be greatly appreciate! How do I eliminate the duplicated names. Thanks!!

And my $count is currently not working as well, it is supposed to be 5 columns per row.

Code: [Select]
<?php
/***Pre-School Level***/
echo '<input name="level[]" type="checkbox" id="level_1" value="1">';
echo '<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>';

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or die(mysqli_error($dbc));

$query = "SELECT sl.subject_level_id, sl.level_id, sl.subject_id, tl.level_name AS level_name, ts.subject_name AS subject_name " .
        "FROM tutor_subject_level AS sl " .
        "INNER JOIN tutor_level AS tl USING (level_id) " .
        "INNER JOIN tutor_subject AS ts USING (subject_id) " .
"ORDER BY subject_level_id ASC LIMIT 7";

    $sql = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));


$query1 = "SELECT subject_level_id FROM tutor_overall_level_subject WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

$sql1 = mysqli_query($dbc, $query1)
or die(mysqli_error($dbc));

$selected_subjects = array();
while ($row = mysqli_fetch_array($sql1)) {
array_push($selected_subjects, $row['subject_level_id']);
}

echo'<table><tr>'; // Start your table outside the loop... and your first row
$count = 0; // Start your counter
while($data = mysqli_fetch_array($sql)) {
/*  Check to see whether or not this is a *new* row
If it is, then end the previous and start the next and restart the counter.
*/
if ($count % 5 == 0) { 
echo "</tr><tr>"; $count = 0;
}
foreach($selected_subjects as $selected_subject) {
if ($data['subject_level_id'] == $selected_subject) {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
else {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
}

} 
echo '</tr></table><br/>'; //Close your last row and your table, outside the loop
?>

This is the end result of the HTML code, through 'view page source' in web browser
Code: [Select]
<input name="level[]" type="checkbox" id="level_1" value="1">

<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>

<table><tr></tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>
</tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td></tr>

</table><br/>

Hi php freaks

I've been learning php, but what confuses me are the arrays.
I have ini file, i want to get the data from file and add it to the database. Every section makes a new table and all they keys are added with their values. I figured out how to get the keys and how to see the values, but how can i get the name of the sections. Furthermore, how do i know what keys belong to what section.

I am really grateful for person who helps me to realize how to be a good friend with those complicated arrays.

Say i wanted to make a list with only female names and i wrote the whole file for it but it kept showing both Male and Female names how would i remove the male names from the list without deleting them out of the SQL?

I wish i knew how to word this better for what I'm looking for....


----------------------------------------------Don't know if you need this----------------------------------------------
MySQL

    Server: Localhost via UNIX socket
    Server version: 5.0.91
    Protocol version: 10
    User: tpkrpgn1@localhost
    MySQL charset: UTF-8 Unicode (utf8)

Web server

    cpsrvd 11.28.64
    MySQL client version: 5.0.91
    PHP extension: mysql

phpMyAdmin

    Version information: 3.3.8.1
----------------------------------------------Don't know if you need this----------------------------------------------

Also is there a way to delete previous posts?

Hi all.  I've got a little function to generate a simple form depending on the input.  What I'd like to do is alias the field names that get output to make them a little more human readable.  However, I'm not entirely sure how to do that with the output that I get.

The function....
function build_form($table_name){
$result=mysql_query("SELECT * FROM $table_name");
$num=mysql_num_rows($result);
$i=1;
echo "<table>";
while ($i < mysql_num_fields($result)) {
$fields=mysql_fetch_field($result,$i);
echo "<tr><td>" . $fields->name . "</td><td><input type=\"text\" size=\"30\" name=\"" . $fields->name . "\" /></td></tr>";
$i++;
};
echo "</table>";
};

Q:  Where would I have to modify the output from mysql_fetch_field?

My modified function...
function build_form($table_name){
$result=mysql_query("SELECT * FROM $table_name");
$num=mysql_num_rows($result);
$i=1;
echo "<table>";
while ($i < mysql_num_fields($result)) {
$fields=mysql_fetch_field($result,$i);
                $field_name=str_replace("_"," ",$fields->name);
echo "<tr><td>" . $field_name . "</td><td><input type=\"text\" size=\"30\" name=\"" . $field_name . "\" /></td></tr>";
$i++;
};
echo "</table>";
};

Not sure if that will work, but am I heading in the right direction?  Any help is much appreciated!

hey guys im getting my column names with this query:

$query = mysql_query("SELECT column_name FROM information_schema.columns WHERE table_name = 'cam_systems'");


I then have an array:

$fields = array(
"cfg_change_date" => "Configuration Change Date",
"system_name" => "System Name",
"system_manf" => "System Manufacturer",
"system_model_no" => "System Model Number",
"system_serial_no" => "System Serial Number",
"system_board_part_no" => "System Board Part Number",
"system_board_serial_no" => "System Board Serial Number",
"asset_tag" => "Asset Tag",
"sla_code" => "SLA Code",
"category" => "Category",
"os_version" => "OS Version",
"os_upgraded" => "OS Upgraded",
"bios_version" => "BIOS Version",
"bios_upgraded" => "BIOS Upgraded",
"ilom_version" => "ILOM Version",
"ilom_ip" => "ILOM IP Address",
"ilom_updated" => "ILOM Updated",
"rack_id" => "Rack ID",
"rack_location_id" => "Rack Location ID",
"tech_id" => "Tech ID",
"warranty" => "Warranty"
);


I need to display these field names now, but rather than the actual column name, I've created an array with column name and then the name I want to actual display. How can I do that? Is their a better way I should be doing this?

IronMineList.php:
Code: [Select]
<?php include('buildingfile.php'); ?>
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT * FROM IMPrints";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$n=1;
$j=0;
$b=1;
while($i<$num) {
$name = mysql_result($result, $i, 'name');
$work = mysql_result($result, $i, 'workers');
$effi = mysql_result($result, $i, 'efficiency');
$cost = mysql_result($result, $i, 'cost');
$iron = mysql_result($result, $i, 'iron');
$copp = mysql_result($result, $i, 'copper');
$silv = mysql_result($result, $i, 'silver');
$titan = mysql_result($result, $i, 'titanium');
$gold = mysql_result($result, $i, 'gold');
$uran = mysql_result($result, $i, 'uranium');
$plat = mysql_result($result, $i, 'platinum');
$diam = mysql_result($result, $i, 'diamonds');
$oil = mysql_result($result, $i, 'oil');
$water = mysql_result($result, $i, 'water');
include('Iron.php'); 
$i++;
$b++;
$j++;
$n++;
}
?>

Iron.php:
Code: [Select]
<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$queryj = "SELECT name FROM IMPrints";
$resultj = mysql_query($queryj);
$Column = mysql_result($resultj, $j);
$queryp = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultp = mysql_query($queryp);
$Base = mysql_fetch_row($resultp);
if(isset($_POST[""])) {
if($_POST[""]) {
$Badd = $Base[$b]+$_POST[""];
$queryi="UPDATE IMBuilt SET $Column=$Badd WHERE idcol = $idcol";
mysql_query($queryi);
}
}
$queryf = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultf = mysql_query($queryf);
$Basic = mysql_fetch_row($resultf);
echo $i;
?>
<p class="bd" id="built">| Built: <?php echo $Basic[$n]; ?> |</p>
<form class="bd" method="post" action="IronMineList.php"><input type="text" name='[]'><input type="submit" value="Build"></form>

What those 2 php documents do is display a list of iron mines a player in my game can build.
It is supposed to create 1 form for each blueprint so that a player can add only to the number of that blueprint on their colony.
The displays work perfectly. It creates 1 div that properly displays the stats of each mine in the database table. It also creates one form for each div.

The problem I have is, I can only make the forms add 1 to all the buildings on a colony.
The name='' value of the form and the $_POST[''] values do not increment with the rest of the code. I need a way to make each form apply only to the div which displays a specific mine.
So where $i=0 the first form should only alter the value in imbuilt for the stats that are displayed by the rest of the div created for $i=0.

Hi Guys,

I use this function to generate seo friendly names for my products once pulled from the database:


function generate_seo_friendly_links($pNM, $pID)
{
    $replacedNM = str_replace(" ", "-", $pNM);  
    $replacedNM = rtrim($replacedNM);  
    $brandNewSEOFriendlyURL = "<a href='$replacedNM-$pID.html'>$pNM</a>";    
    return $brandNewSEOFriendlyURL;
}


This works great, the only thing is say a product is stored in the database like:

product name it would then be converted to: product-name.html

if for example theres 2 spaces:

product  name it would then be converted to: product--name.html

with the 2 "--" so for every space it finds we replace with a "-" etc

is there a way i could ignore more than 1 space and always have it like product-name-here.html so the names are more uniformed, i can't think of a way to do it.

any help would be appreciated

thanks guys

Graham

In my forms, at the top, I have PHP that fires if the Form was submitted like this...

// *************************************************************
// HANDLE FORM.  *
// *************************************************************
if ($_SERVER['REQUEST_METHOD']=='POST'){
// Form was Submitted (Post).

// Initialize Errors Array.
$errors = array();

// Trim all form data.
$trimmed = array_map('trim', $_POST);



And then at the bottom of the file I have my HTML Form with controls like this...

<!-- First Name -->
<label for="firstName"><b>*</b>First Name:</label>
<input id="firstName" name="firstName" type="text" maxlength="30"
value="<?php if(isset($firstName)){echo htmlentities($firstName, ENT_QUOTES);} ?>" /><!-- Sticky Field -->
<?php
if (!empty($errors['firstName'])){
echo '<span class="error">' . $errors['firstName'] . '</span>';
}
?>



Where is this code getting the name "$firstName"...

<?php if(isset($firstName))



I guess I am asking what in my Form determines the name of things in the $_POST array??

Hope that makes sense?!


Debbie