Hi,
Has this been done before if so please point me in the right direction?
I have a form search html page that when a number is input, from a single input box it returns the results of the request as a html page (see the code returned below).
I have two questions
A how do I extract the information from the page example name, request, ID, Make, Model etc without the html.
Two, how would I get it into a form so it could be further edited or automated into DBman
In essences I would like to extract the data form the returned html below and put it into DBman.
Has automated add to DBMAN been discussed as I have not been able to find anything?
Any help here would be a appreciated.
Thanks for your time
Norvin
################ CODE RETURNED FROM SEARCH
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>aaa</title>
<style type="text/css">
<!--
html,body {
margin: 0;
padding: 0;
height: 100%;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.normtext {
font-family: Verdana, sans-serif;
font-size: 12px;
font-weight: bold;
color: #000000;
margin:0;
}
.normwhite {
font-family: Verdana, sans-serif;
font-size: 12px;
font-weight: bold;
color: #ffffff;
margin:0;
}
.input {
font-family: Verdana, sans-serif;
font-size:12px;
font-weight:bold;
color:#3e3f76;
background-color:#EFEFEF;
border:1px solid #C3C0B2;
}
-->
</style>
</head>
<body>
<br><br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td class='normwhite'>Ref Number</td>
<td class='normwhite'>Name</td>
<td class='normwhite'>Telephone</td>
<td class='normwhite'>E-Mail</td>
<td class='normwhite'>Make</td>
<td class='normwhite'>Model</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>OG464675</td>
<td class='normtext'>N SIMONDO</td>
<td class='normtext'>01709 378675</td>
<td class='normtext'>fred@i-have.info</td>
<td class='normtext'>1986 AUDI</td>
<td class='normtext'>100</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td class='normwhite'>Date</td>
<td class='normwhite'>VRM</td>
<td class='normwhite'>Body Style</td>
<td class='normwhite'>Engine</td>
<td class='normwhite'>Fuel</td>
<td class='normwhite'>Trans</td>
<td class='normwhite'>Location</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>2007-01-15 13:34:20</td>
<td class='normtext'></td>
<td class='normtext'>4 DOOR</td>
<td class='normtext'>2300</td>
<td class='normtext'>PETROL</td>
<td class='normtext'>5 SPEED MANUAL</td>
<td class='normtext'>NORTH</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td width='20%' class='normwhite'>Part</td>
<td class='normwhite'>Description</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>BONNET</td>
<td class='normtext'>Bonnet</td>
</tr>
</table>
</td>
</tr>
</table>
<br><br>
<form action="refsearch.php" method="POST">
<table width="300" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td bgcolor="#000000">
<table width="300" border="0" cellpadding="0" cellspacing="0" align="center">
<tr align="center" bgcolor="#000000">
<td height="18" colspan="2"><span class="normwhite">Search By Reference Number </span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" class="normtext">Reference: </td>
<td valign="middle"><input name="reference" type="text" size="15" class="input">
<input name="Search" type="submit" class="input" value="Search"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
Has this been done before if so please point me in the right direction?
I have a form search html page that when a number is input, from a single input box it returns the results of the request as a html page (see the code returned below).
I have two questions
A how do I extract the information from the page example name, request, ID, Make, Model etc without the html.
Two, how would I get it into a form so it could be further edited or automated into DBman
In essences I would like to extract the data form the returned html below and put it into DBman.
Has automated add to DBMAN been discussed as I have not been able to find anything?
Any help here would be a appreciated.
Thanks for your time
Norvin
################ CODE RETURNED FROM SEARCH
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>aaa</title>
<style type="text/css">
<!--
html,body {
margin: 0;
padding: 0;
height: 100%;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.normtext {
font-family: Verdana, sans-serif;
font-size: 12px;
font-weight: bold;
color: #000000;
margin:0;
}
.normwhite {
font-family: Verdana, sans-serif;
font-size: 12px;
font-weight: bold;
color: #ffffff;
margin:0;
}
.input {
font-family: Verdana, sans-serif;
font-size:12px;
font-weight:bold;
color:#3e3f76;
background-color:#EFEFEF;
border:1px solid #C3C0B2;
}
-->
</style>
</head>
<body>
<br><br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td class='normwhite'>Ref Number</td>
<td class='normwhite'>Name</td>
<td class='normwhite'>Telephone</td>
<td class='normwhite'>E-Mail</td>
<td class='normwhite'>Make</td>
<td class='normwhite'>Model</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>OG464675</td>
<td class='normtext'>N SIMONDO</td>
<td class='normtext'>01709 378675</td>
<td class='normtext'>fred@i-have.info</td>
<td class='normtext'>1986 AUDI</td>
<td class='normtext'>100</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td class='normwhite'>Date</td>
<td class='normwhite'>VRM</td>
<td class='normwhite'>Body Style</td>
<td class='normwhite'>Engine</td>
<td class='normwhite'>Fuel</td>
<td class='normwhite'>Trans</td>
<td class='normwhite'>Location</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>2007-01-15 13:34:20</td>
<td class='normtext'></td>
<td class='normtext'>4 DOOR</td>
<td class='normtext'>2300</td>
<td class='normtext'>PETROL</td>
<td class='normtext'>5 SPEED MANUAL</td>
<td class='normtext'>NORTH</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width='90%' border='0' align='center' cellpadding='1' cellspacing='0'>
<tr>
<td bgcolor='#000000'>
<table width='100%' border='0' cellpadding='1' cellspacing='0'>
<tr bgcolor='#000000'>
<td width='20%' class='normwhite'>Part</td>
<td class='normwhite'>Description</td>
</tr>
<tr bgcolor='#FFFFFF'>
<td class='normtext'>BONNET</td>
<td class='normtext'>Bonnet</td>
</tr>
</table>
</td>
</tr>
</table>
<br><br>
<form action="refsearch.php" method="POST">
<table width="300" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td bgcolor="#000000">
<table width="300" border="0" cellpadding="0" cellspacing="0" align="center">
<tr align="center" bgcolor="#000000">
<td height="18" colspan="2"><span class="normwhite">Search By Reference Number </span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" class="normtext">Reference: </td>
<td valign="middle"><input name="reference" type="text" size="15" class="input">
<input name="Search" type="submit" class="input" value="Search"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>