PHP - Host Can't Solve My Issue

Can some PHP guru help me with this scenarios? I've been wondering around these for hours and can't find my way around  it. Please...

1.
Write a function in PHP that takes three parameters (representing day, month and year) and calculates the day/month/year of the following day (for example, if the parameter is 31/10/2010, the result should be 01/11/2010). No need to take into account leap years. You cannot use any date/time specific functions, you must do it "by hand" (no built-in functions)..

2.
Write a function in PHP that takes a string and counts the number of occurrences of any given letter in it (for example, given the string "HELLO" as a parameter, there are two occurrences of "L", one of "H", one of "E", one of "O" and zero of any other character).

Code: [Select]
Warning: SimpleXMLElement::addChild() [simplexmlelement.addchild]: unterminated entity reference limit=50&method=GET&access_token=AAACd5Mcn7VQBAKaupEZCocujRuoBzzWeZCj945ZApHEsv5BZAxZCJfS62cSSz4txlZBUZAec03GcjpHdk0NTotnglt2ZB41GzzeYl8xqIZBmsvlS6UZAoHZB1A4&offset=50 in /home/content/71/8432771/html/facebook/get/friends.php on line 62

Code: [Select]
<?php
/**
 * Copyright 2011 Facebook, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may
 * not use this file except in compliance with the License. You may obtain
 * a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations
 * under the License.
 */

require '../../src/facebook.php';

// Create our Application instance (replace this with your appId and secret).
$facebook = new Facebook(array(
  'appId'  => 'APPID',
  'secret' => 'SECRET',
));

// Get User ID
$user = $facebook->getUser();

// We may or may not have this data based on whether the user is logged in.
//
// If we have a $user id here, it means we know the user is logged into
// Facebook, but we don't know if the access token is valid. An access
// token is invalid if the user logged out of Facebook.

if ($user) {
  try {
    // Proceed knowing you have a logged in user who's authenticated.
    $user_profile = $facebook->api('/me/friends?fields=id,name,first_name,last_name,picture&limit=50');
  } catch (FacebookApiException $e) {
    error_log($e);
    $user = null;
  }
}

// Login or logout url will be needed depending on current user state.
if ($user) {
  $logoutUrl = $facebook->getLogoutUrl();
} else {
  $loginUrl = $facebook->getLoginUrl();
}

$profile = array ($user_profile);
$xml = new SimpleXMLElement('<root/>');

arrayToXML( $xml, $profile );

echo $xml->asXML();

function arrayToXML( SimpleXMLElement &$xml, $array ) {
foreach( $array as $name => $value ) {
if( !is_array($value) )
$xml->addChild( $name, $value );
else {
$child = $xml->addChild( $name );   <----------------------------------------------LINE 64
arrayToXML( $child, $value );
}
}
}

?>

Here is the array

Code: [Select]
{
   "data": [
      {
         "name": "Pauline Latty",
         "id": "312293"
      },
      {
         "name": "Noah Ethan Schinasi",
         "id": "55101245"
      },
      {
         "name": "Luis Guerrero",
         "id": "194803212"
      },
      {
         "name": "Nakia Johnson",
         "id": "500350828"
      },
      {
         "name": "Bethany Vallerie",
         "id": "502062429"
      },
      {
         "name": "Caroline Franks",
         "id": "505331027"
      },
      {
         "name": "Andrew Shivers",
         "id": "505749817"
      },
      {
         "name": "Sandra G Garcia",
         "id": "508006303"
      },
      {
         "name": "Catherine Davis",
         "id": "511006416"
      },
      {
         "name": "Marc Watson",
         "id": "511201074"
      },
      {
         "name": "Laura Clarke",
         "id": "513653820"
      },
      {
         "name": "Amanda Rice",
         "id": "514062403"
      },
      {
         "name": "Scott Alan Buss",
         "id": "514197867"
      },
      {
         "name": "Evangelist Josephus",
         "id": "515837621"
      },
      {
         "name": "Chet Fontenot",
         "id": "516199085"
      },
      {
         "name": "Sharon Howard",
         "id": "516580144"
      },
      {
         "name": "Chatt Franco",
         "id": "517211511"
      },
      {
         "name": "Lydgia Vanessa Staples",
         "id": "518094760"
      },
      {
         "name": "Corry Bell",
         "id": "521043483"
      },
      {
         "name": "Lessie Tyson",
         "id": "521855454"
      },
      {
         "name": "Jawahar Peter",
         "id": "523159934"
      },
      {
         "name": "Sheena Shiko",
         "id": "523461577"
      },
      {
         "name": "Pat Larry Thomas",
         "id": "523555768"
      },
      {
         "name": "Oyenuga Kunle Johnson Matthew",
         "id": "524263978"
      },
      {
         "name": "Angela Whitten",
         "id": "524631356"
      }
   ],
   "paging": {
      "next": "https://graph.facebook.com/me/friends?limit=25&access_token=2227470867|2.AQAMMvJya05xkLhR.3600.1318057200.0-100001957015772|IUAhNlekyalf7sxy-OjdJd7KCwo&offset=25"
   }
}
its that paging, I can not seem to get that to work yet.

This is how it should look.
basic xml file
http://wiistream.net/php/user/pictures/gallery.xml
but this is how it looks.
http://wiistream.net/php/user/pictures/gallery.php?username=Mancent&user_folder=Mancent_Pictures
mysql php xml file with category's.

This is whats making it so hard the category's
Im using 3 tables one table is for my friends
and one table is the category folder name
and the other table is the picture holder with the category folder name

so I thought i could do a if statement
if user_folder = user_folder

from the two tables it would keep the correct images in the correct category.
But 3 weeks later still no luck.

Heres what I got so far.
<?php
//lets get the mysql connection information.
include "../../connect.php";
//we need this because the flash stores the xml file in temp internet history.
Header('Cache-Control: no-cache');
Header('Pragma: no-cache');
//ok flash sent out the username
$username = mysql_real_escape_string($_GET['username']);
//ok flash sent out the folder name
$user_folder = mysql_real_escape_string($_GET['user_folder']);

$user_folder = (isset($_GET['friend'])) ? ' AND b.user_folder = \'' . mysql_real_escape_string($_GET['user_folder']) . '\' ' : NULL;
//this part will be used becasue we need to see if friendship has ben made.
$friend = (isset($_GET['friend'])) ? ' AND b.friend = \'' . mysql_real_escape_string($_GET['friend']) . '\' ' : NULL;
//Ok lets select the username from the accounts table to see if they are a user..
$get_username = "SELECT * FROM accounts WHERE username = '$username'";
$username_results = mysql_query($get_username) or die("Data not found."); 
//Get the number of results from the query.
$check_username_mysql_rows = mysql_num_rows($username_results);




//If there is a match for the username, echo the the users xml data.
if($check_username_mysql_rows == 1) 
{

$sql1 = "SELECT a.username,a.user_folder,b.username FROM user_image_folders as a JOIN `user_friends_list` as b ON (b.friend = a.username)WHERE (b.username = '$username' $user_folder $friend AND b.status = 1)";
$result1 = mysql_query($sql1);


//TODO MAKE THE FRIENDSHIP WORK WITH THIS
$sql = "SELECT a.username,a.user_folder,a.user_folder,a.large_pic,a.small_pic,a.pic_title,a.pic_discription,b.username FROM user_photo_gallery as a JOIN `user_friends_list` as b ON (b.friend = a.username)WHERE (b.username = '$username' $user_folder $friend AND b.status = 1)";
$result2 = mysql_query($sql);


$user_xml = "<?xml version=\"1.0\"?>\n";
$user_xml .= "<settings>\n";
$user_xml .= "<sceneHeight>600</sceneHeight>\n";
$user_xml .= "<sceneWidth>1000</sceneWidth>\n";
$user_xml .= "<titleColor>#000000</titleColor>\n";
$user_xml .= "<descriptionBgAlpha>70</descriptionBgAlpha>\n";
$user_xml .= "<showFullscreenBtn>no</showFullscreenBtn>\n";
$user_xml .= "<waterMark useImage=\"no\"><![CDATA[THIS]]></waterMark>\n";
$user_xml .= "</settings>\n";
$user_xml .="<galleries>\n";

//{
while ($i_get_myfriends = mysql_fetch_assoc($result1))
{


$user_xml .="<gallery theName=\"". $i_get_myfriends['user_folder'] ."\" itemsPerRow=\"3\" autoStart=\"no\" playTime=\"5\" autoResize=\"yes\" xOffset=\"5\" yOffset=\"10\" showTitleOnThumbs=\"yes\" allowDownload=\"yes\">\n";



while ($i_get_myfriends2 = mysql_fetch_assoc($result2))
{
//if($i_get_myfriends['user_folder'] ==$i_get_myfriends2['user_folder'])
//{
$user_xml .="<picture largePicture=\"". $i_get_myfriends2['large_pic'] ."\" smallPicture=\"". $i_get_myfriends2['small_pic'] ."\" theTitle=\"". $i_get_myfriends2['pic_title'] ."\"><![CDATA[". $i_get_myfriends2['pic_discription'] ."]]>\n";
$user_xml .="</picture>\n";
//}
}




$user_xml .="</gallery>\n";
}


$user_xml .="</galleries>\n";
echo $user_xml; 
}
else
{
echo "Wiistream Eorror!\n";
}

?>

See all the images are going into one folder.. and they are sopost to go into the friends folder it they are the friends pictures.

but they are all in my folder..
 

This topic has been moved to Third Party PHP Scripts.

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

Hello guys, I'm trying to solve my hometask . I tried in many different ways to solve the task related with Advanced SQL Syntax. Please check the pic below:


The Quiz is asking for make location appear in all uppercase letters, the character associated with a given ASCII value and the table is people. I tried the last one in this way:
SELECT CONCAT(name,'is from',strtoupper(location),' The ASCII character of the number ',number,' is ',ASCII(number)) FROM `people` WHERE 1

but it doesn't work. Can someone help me?

Thanks

I have following errors in below coding. Can anyone point out me where i went wrong??

Undefined variables:

fname,focu,foad,ftp,fmf,mname,mocu,moad,mtp,mmf,gname,gocu,goadd,gtp,gmf in C:\wamp\www\Student registration\manage studnt parent details\manageStudentRegistrationParentDetailsForm.php


manageStudentRegistrationParentDetailsForm.php

Code: [Select]
<?php
$query="SELECT state,name,occupation,office_address,office_telephone,mobile_number FROM parent_info
where admission_no='$admission_no'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){


$first=$row['state'];

if($first=='father'){
$fname=$row['name'];
$focu=$row['occupation'];
$foadd=$row['office_address'];
$ftp=$row['office_telephone'];
$fmf=$row['mobile_number'];

}
if($first=='mother'){
$mname=$row['name'];
$mocu=$row['occupation'];
$moadd=$row['office_address'];
$mtp=$row['office_telephone'];
$mmf=$row['mobile_number'];
}
if($first=='guardians'){
$gname=$row['name'];
$gocu=$row['occupation'];
$goadd=$row['office_address'];
$gtp=$row['office_telephone'];
$gmf=$row['mobile_number'];
}

}

?>
----
----

<tr>
<td>&nbsp;</td>
<td colspan="5"><h3>
<label><strong>Parents/Guardian information</strong></label>
<strong>&nbsp;</strong></h3></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><label>Admission No</label>&nbsp;</td>
<td colspan="2" align="left"><?php echo $admission_no ;?></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>

<tr>
<td>&nbsp;</td>
<td colspan="2">
<input type="checkbox" name="checkbox" id="checkbox" <?php if($fname!=null){ ?> checked="checked" <?php }?> onclick="father()" />
<label>fathers details</label></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label> Name</label>&nbsp;</td>
<td><input type="text" name="Name1" id="textfield" value="<?php echo $fname; ?>" disabled="disabled" /></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Occupation</label>&nbsp;</td>
<td>

<input type="text" name="Occupation1" id="textfield2" value="<?php echo $focu; ?>" disabled="disabled"/>

</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Address</label>&nbsp;</td>
<td>

<textarea name="Office_Address1" id="office_address" cols="45" rows="5" disabled="disabled"><?php echo $foadd; ?></textarea>

</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Telephone Number</label>
&nbsp;</td>
<td>

<input type="text" name="Office_tel1" id="textfield4" value="<?php echo $ftp; ?>" disabled="disabled" />

</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Mobile Phone Number</label></td>
<td>

<input type="text" name="Mobile_pho1" id="textfield5" value="<?php echo $fmf; ?>" disabled="disabled" />

</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">
<input type="checkbox" name="checkbox2" id="checkbox2" <?php if($mname!=null){ ?> checked="checked" <?php }?> onclick="mother()" />
<label>Mothers details</label></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label> Name</label>&nbsp;</td>
<td>
<input type="text" name="Name2" id="textfield3" value="<?php echo $mname; ?>" disabled="disabled"/>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Occupation</label>&nbsp;</td>
<td>
<input type="text" name="Occupation2" id="textfield7" value="<?php echo $mocu; ?>" disabled="disabled"/>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Address</label>&nbsp;</td>
<td>
<textarea name="Office_Address2" id="textarea" cols="45" rows="5" disabled="disabled"><?php echo $moadd; ?></textarea>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Telephone Number</label>&nbsp;</td>
<td>
<input type="text" name="Office_tel2" id="textfield8" value="<?php echo $mtp; ?>" disabled="disabled" />
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Mobile Phone Number</label>&nbsp;</td>
<td>
<input type="text" name="Mobile_pho2" id="textfield9" value="<?php echo $mmf; ?>" disabled="disabled" />
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">
<input type="checkbox" name="checkbox3" id="checkbox3" <?php if($gname!=null){ ?> checked="checked" <?php }?> onclick="Guardian()"/>
<label>Guardian details</label></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label> Name</label>&nbsp;</td>
<td>
<input type="text" name="Name3" id="textfield6" value="<?php echo $gname; ?>" disabled="disabled"/>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Occupation</label>&nbsp;</td>
<td>
<input type="text" name="Occupation3" id="textfield10" value="<?php echo $gocu; ?>" disabled="disabled"/>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Address</label>&nbsp;</td>
<td>
<textarea name="Office_Address3" id="textarea2" cols="45" rows="5" disabled="disabled"><?php echo $goadd; ?></textarea>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td></tr>
<tr>
<td>&nbsp;</td>
<td colspan="2"><label>Office Telephone Number</label>&nbsp;</td>
<td>
<input type="text" name="Office_tel3" id="textfield11" value="<?php echo $gtp; ?>" disabled="disabled"/>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr><td>&nbsp;</td>
<td colspan="2"><label>Mobile Phone Number</label>&nbsp;</td>
<td>
<input type="text" name="Mobile_pho3" id="textfield12" value="<?php echo $gmf; ?>" disabled="disabled" />
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>

<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>

<input type="submit" name="button" id="button" value="Save" />

</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p></td>
</tr>

My code is

$answer = (1/212500);
output is

4.90205690308E-6

while I need I output as
0.00000470588

Please help, and tell me what is the specific problem,

I changed web hosting companies and now a php form that was working is no longer working. I haven't been able to figure out what the problem is. The form is a simple text input form that adds the text to a database. Every time the user inserts text with a comma, an error occurs. Below is the code for the form. Any help is much appreciated.

Hi,

My hosting company (Bluehost) told me when someone goes to my home page, it sends these series of queries and this is the reason for my high cpu usage and this is why my site says Error Establishing Database. The hosting company gave me these:

Each script is using a decent about of CPU.
[2:09:33 AM] hollane3 31881 6.2 0.1 186084 49000 ? RN 01:59 0:26 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 934 6.6 0.1 184012 48652 ? RN 01:59 0:25 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 5344 7.1 0.1 184008 48440 ? RN 02:01 0:21 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php
hollane3 5164 7.1 0.1 186444 48772 ? RN 02:01 0:22 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 7246 6.9 0.1 184116 48196 ? RN 02:02 0:18 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 11221 5.8 0.1 185160 47852 ? RN 02:03 0:09 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 11236 6.4 0.1 182992 47620 ? RN 02:03 0:10 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php
hollane3 12595 5.4 0.1 183088 47264 ? RN 02:04 0:07 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 13969 5.4 0.1 184648 47396 ? RN 02:04 0:05 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 14161 6.1 0.1 182480 47140 ? RN 02:04 0:06 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php
hollane3 14198 6.7 0.1 183092 47204 ? RN 02:04 0:06 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php
hollane3 16343 4.9 0.1 181968 46496 ? RN 02:05 0:02 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php

I am not well versed with scripting, so I don't know what this mean.    Can anyone PLEASE help me to answer these questions:

+ Is this related to a particular plugin or widget or theme?
+ What could be the possible source of this issue, that is, which file should I look at to resolve this?
+ Can I fix this myself or do I need a php coder to help me?

Thanks!

HI,
My host support pop protocol. I want my host to receive emails and do some process on it with php coding and then store then.But I don't know how to receive emails using my host and how can I have access to them to do some process on it.
How can I do that?

Thanks 

Hi all,
I have a small script I found somewhere but after I changed hosting, it just stop to work. I just want to record the user IP and Referrer etc. in a .txt file using fopen.
It helps to see what users searched for in search engine etc.
The headers are there but no data... Please help??

session_start();
if($session["logged"] != "yes")
{
$agent = $_SERVER['HTTP_USER_AGENT'];
$uri = $_SERVER['REUEST_URI'];
$ip = $_SERVER['REMOTE_ADDR'];
$ref = $_SERVER['HTTP_REFERER'];
$visitTime = date("r");
$logLine = "$visitTime - IP: $ip || User Agent: $agent || Page: $uri || Refererrer: $ref\n\n";
$fp = fopen("indexLog.txt", "a");
fputs($fp, $logLine);
fclose($fp);
$_SESSION["logged"] = "yes";
}
?>

Thanx in advance
Jaco

<!DOCTYPE html>
<html>
<body>
<form action="Practice 1.1.php" method="post">
Catagory Code:<input type="text" name="n" size="2"><br>
Units Used <input type="text" name="u" size="2">
<br>
<input type="submit" value="Calculate">
</form>
<?php
$a=$_POST['n'];
$b=$_POST['u'];
if ($b<=3.75) {
	echo "";
}

?>
</body>
</html>

 

Hi, i have this code
Code: [Select]
print get_domain("http://www.somedomain.com");

function get_domain($url)
{
  $pieces = parse_url($url);
  $domain = isset($pieces['host']) ? $pieces['host'] : '';
  if (preg_match('/(?P<domain>[a-z0-9][a-z0-9\-]{1,63}\.[a-z\.]{2,6})$/i', $domain, $regs)) {
    return $regs['domain'];
  }
  return false;
}
 mysql_query("INSERT INTO table VALUES('', '$domain')");

And i want to check that the www.somedomain.com is not an ipaddress or localhost (i.e.
localhost,
127.*.*.*,  - Local
192.168.*.* -LAN
or *.*.*.* (as an ip) - Actual IP

Any help would be much appreciated


thanks,

jack

Im trying to add value into my database and i keep getting the following error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','','4','Telegraph (IRE)','3','9-3','','57','Evans, P D','28/1 ','Egan, John '' at line 1"
 
my query looks like this

mysqli_query($db,"INSERT INTO `Horses` (`Date`,`Track`,`Runners`, `Going`, `Distance`,`Class`,`Place`,`Losing_Dist`,`Stall`,`Horse`,`Age`,`Weight`,`Headgear`,`Horse_OR`,`Trainer`,`Odds`,`Jockeys_Claim`,`Comments`,`Race_Name` )VALUES ('$date','$place','$norunner','$going','$distance','$class',$place','$distance_bt','$stall','$horse','$age','$weight','$headgear','$OR','$trainer','$odds','$jockey','$comments','$event')")or die(mysqli_error($db));

and my table looks like this:

Column      Type      Null      Default
ID      int(255)      No      
Date      varchar(250)      Yes      NULL
Track      varchar(100)      Yes      NULL
Runners      varchar(50)      Yes      NULL
Going      varchar(50)      Yes      NULL
Distance      varchar(50)      Yes      NULL
Class      varchar(50)      Yes      NULL
Place      varchar(10)      Yes      NULL
Losing_Dist      varchar(50)      Yes      NULL
Stall      varchar(250)      Yes      NULL
Horse      varchar(50)      Yes      NULL
Age      varchar(50)      Yes      NULL
Weight      varchar(50)      Yes      NULL
Headgear      varchar(50)      Yes      NULL
Horse_OR      varchar(50)      Yes      NULL
Trainer      varchar(50)      Yes      NULL
Odds      varchar(50)      Yes      NULL
Jockeys_Claim      varchar(50)      Yes      NULL
Comments      varchar(250)      Yes      NULL
Race_Name      varchar(250)      Yes      NULL

I am using the free web host http://www.byethost2.com/ and need help figuring out where and how to make my php files to?!

Currently I have the following Config file...
Code: [Select]
<?php
// Build Date: 2011-12-17 1:15pm

// Website Environment
define('ENVIRONMENT', 'development');
//define('ENVIRONMENT', 'production');


// Web Root (aka Document Root) (**Physical Location)
define('WEB_ROOT', ENVIRONMENT === 'development'
? '/Users/user1/Documents/DEV/++htdocs/05_Debbie/'
: '/var/www/vhosts/MySite.com/httpdocs/');


// Base URL (**Virtual Location)
define('BASE_URL', ENVIRONMENT === 'development'
? 'http://local.debbie/'
: 'http://www.MySite.com/');
?>
What am I supposed to use for WEB_ROOT and BASE_URL on this free hosting site?!


Currently, to view my test website you go to...
http://www.doubledee.byethost2.com/

I suppose that could be "BASE_URL", but for where things are physically stored so I can redefine "WEB_ROOT" I have no clue...   

Help!

Thanks,


Debbie