How to check before insert with xml

[postonoh]

Hello PHP World,

I don't have access to the database yet for the project I am working on so I created a work around until I get full access to the mysql database.

 

I

<?php

	$xml_file = "affiliate.xml";		

	// OPEN XML FILE ######################################################

	if(!$xml=simplexml_load_file($xml_file)){
	    trigger_error('Error reading XML file',E_affiliate_ERROR);
	}
if(!empty($_GET['add'])){

           
		$u_name = stripslashes($_POST['name']);
		$u_company = stripslashes($_POST['company']);
		$u_address = stripslashes($_POST['address']);
		$u_city = stripslashes($_POST['city']);
		$u_state = stripslashes($_POST['state']);
		$u_phone = stripslashes($_POST['phone']);
		$u_email = stripslashes($_POST['email']);
		$u_desc = stripslashes($_POST['description']);
		$u_region = stripslashes($_POST['region']);

		// Generate new (appended) ID

		foreach($xml as $affiliate){
		    $last_id = $affiliate->uid;
		}

		$id = $last_id+1;

		// Add node

		$x = $xml->addChild("affiliate");
		$x->addChild("uid",$id);
		$x->addChild("name",$u_name);
		$x->addChild("company",$u_company);
		$x->addChild("address",$u_address);
		$x->addChild("city",$u_city);
		$x->addChild("state",$u_state);
		$x->addChild("phone",$u_phone);
		$x->addChild("email",$u_email);
		$x->addChild("description",$u_desc);
		$x->addChild("region",$u_region);

		$xml->asXML($xml_file);

	}
?>

 

 

html form

 

<br />
	<br />

	<h1>Affiliate </h1>

	<form name="xml_writing" method="post" action="?add=t">
	<table width="393">
	<tr><td width="56">
	Name:<br /></td><td width="206">
	<input type="text" name="name" width="150"/></td>
	<td>Region:</td>
	<td><select name="region" value="options">
	<option value="resellerNE">NorthEast</option>
	<option value="resellerSE">SouthEast</option>
	<option value="resellerC">Central</option>
	<option value="resellerNE">NorthWest</option>
	<option value="resellerNE">SouthWest</option>
	<option value="resellerNE">International</option>	
	</select></td>
	</tr>
	<tr>
	<td>
	Company:<br /></td><td>
	<input type="text" name="company" width="150" /></td>
	</tr>
	<tr><td>
	Address:<br /></td><td>
	<input type="text" name="address" width="150"/></td>
	</tr>
	<tr><td height="45">
	City:<br /></td><td>
	<input type="text" name="city" width="150"/></td>
	<tr><td>
	State:<br /></td><td>
	<input type="text" name="state" width="150"/></td>
	<tr><td>
	Phone:<br /></td><td>
	<input type="text" name="phone" width="150"/></td>
	<tr><td>
	Email:<br /></td><td>
	<input type="text" name="email" width="150"/></td>
	</tr>

	<tr><td colspan="2">
	Short description of yourself, your practice, your services, and other information of interest to potential clients or collaborators.<br /></td>
	<tr><td colspan="2">
	<textarea name="description" style="width: 406px; height: 136px;"></textarea></td>
	</tr>
	<tr><td></td><td>
	<input type="submit" value="Submit" /></td>
	</tr>
	</table></form>

What I am trying to do is have on submit check against the email node in the xml file to see if email exist.

if exist string already a member else insert.

 

if you can help with code or point to something that will help.

 

 

"Everyone needs a mentor to lead them into success."

Quote by Shelby Poston

 

[postonoh]

Hello PHP World,

I don't have access to the database yet for the project I am working on so I created a work around until I get full access to the mysql database.

 

I know how to do it with the database

 

$query "SELECT email FROM owners WHERE email = '$u_email' ":

$result = mysql_query($query) or die(mysql_error());

 

if(mysql_affected_rows())

 

{

 

}else

{

 

}

 

trying figure out with xml.

 

 

 

I

<?php

	$xml_file = "affiliate.xml";		

	// OPEN XML FILE ######################################################

	if(!$xml=simplexml_load_file($xml_file)){
	    trigger_error('Error reading XML file',E_affiliate_ERROR);
	}
if(!empty($_GET['add'])){

           
		$u_name = stripslashes($_POST['name']);
		$u_company = stripslashes($_POST['company']);
		$u_address = stripslashes($_POST['address']);
		$u_city = stripslashes($_POST['city']);
		$u_state = stripslashes($_POST['state']);
		$u_phone = stripslashes($_POST['phone']);
		$u_email = stripslashes($_POST['email']);
		$u_desc = stripslashes($_POST['description']);
		$u_region = stripslashes($_POST['region']);

		// Generate new (appended) ID

		foreach($xml as $affiliate){
		    $last_id = $affiliate->uid;
		}

		$id = $last_id+1;

		// Add node

		$x = $xml->addChild("affiliate");
		$x->addChild("uid",$id);
		$x->addChild("name",$u_name);
		$x->addChild("company",$u_company);
		$x->addChild("address",$u_address);
		$x->addChild("city",$u_city);
		$x->addChild("state",$u_state);
		$x->addChild("phone",$u_phone);
		$x->addChild("email",$u_email);
		$x->addChild("description",$u_desc);
		$x->addChild("region",$u_region);

		$xml->asXML($xml_file);

	}
?>

 

 

html form

 

<br />
	<br />

	<h1>Affiliate </h1>

	<form name="xml_writing" method="post" action="?add=t">
	<table width="393">
	<tr><td width="56">
	Name:<br /></td><td width="206">
	<input type="text" name="name" width="150"/></td>
	<td>Region:</td>
	<td><select name="region" value="options">
	<option value="resellerNE">NorthEast</option>
	<option value="resellerSE">SouthEast</option>
	<option value="resellerC">Central</option>
	<option value="resellerNE">NorthWest</option>
	<option value="resellerNE">SouthWest</option>
	<option value="resellerNE">International</option>	
	</select></td>
	</tr>
	<tr>
	<td>
	Company:<br /></td><td>
	<input type="text" name="company" width="150" /></td>
	</tr>
	<tr><td>
	Address:<br /></td><td>
	<input type="text" name="address" width="150"/></td>
	</tr>
	<tr><td height="45">
	City:<br /></td><td>
	<input type="text" name="city" width="150"/></td>
	<tr><td>
	State:<br /></td><td>
	<input type="text" name="state" width="150"/></td>
	<tr><td>
	Phone:<br /></td><td>
	<input type="text" name="phone" width="150"/></td>
	<tr><td>
	Email:<br /></td><td>
	<input type="text" name="email" width="150"/></td>
	</tr>

	<tr><td colspan="2">
	Short description of yourself, your practice, your services, and other information of interest to potential clients or collaborators.<br /></td>
	<tr><td colspan="2">
	<textarea name="description" style="width: 406px; height: 136px;"></textarea></td>
	</tr>
	<tr><td></td><td>
	<input type="submit" value="Submit" /></td>
	</tr>
	</table></form>

What I am trying to do is have on submit check against the email node in the xml file to see if email exist.

if exist string already a member else insert.

 

if you can help with code or point to something that will help.

 

 

"Everyone needs a mentor to lead them into success."

Quote by Shelby Poston