Functions in Description

June 29, 2006

Hi guys,

I am currently facing the following issues.

1. MySQL database upload limit capped at 2mb & database size limit capped at 30mb.

2. After adding 115 products, my total sql database size is already about 600k.

To generate this product this is my code.

<p>The all new HSR-5995TG was designed specifically to meet the demanding needs of rising robotics applications. Incorporating the latest Titanium gear technology and unique case design, the HSR-5995TG servo has all the features you would expect from a robotics servo.</p>

<p>If your looking for the ultimate hobby robotics servo, you found it. Hitec is proud to announce the amazing HRS-5995TG Digital Robotic Servo created specifically for the hobby robotics market. Offering a staggering 30.0kg-cm of torque in a standard sized servo case, the HSR-5995TG uses a powerful coreless motor and Hitec's latest Titanium geartrain technology.</p>

<p>Designed to operate up to 7.4 volts, and featuring an exclusive "pivot" mount, the Hitec HRS-5995TG servo also rotates 180Â° compared to the traditional 75Â° that most R/C servos travel. To contain all this brute force, Hitec's servo engineers incorporated axial brass bearings into the upper case for the new hardened steel gear shafts.</p>

<p>Using Hitec's HFP-10 Servo Programmer, users of the HSR-5995TG servo is able to program end and center points, dead band width, speed and other functions.</p>

<table cellspacing="0" cellpadding="2" width="100%" border="0">

	<tbody>

		<tr>

			<th valign="top" width="100%" bgcolor="#0000ff" colspan="2">

			<p><font color="#ffffff"><u><b>Servo Specifications</b></u></font></p>

			</th>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Order Code</b></u></font></p>

			</td>

			<td width="60%">

			<p>AM00110</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Product</b></u></font></p>

			</td>

			<td width="60%">

			<p>HSR-5995TG</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Type</b></u></font></p>

			</td>

			<td width="60%">

			<p>Digital Robotic Servo w/Titanium Gears</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Control System</b></u></font></p>

			</td>

			<td width="60%">

			<p>+Pluse Width Control 1500Âµsec Netural</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Required Pulse</b></u></font></p>

			</td>

			<td width="60%">

			<p>3.3-7.4 Volt Peak to Peak Square Wave</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Operating Voltage Range</b></u></font></p>

			</td>

			<td width="60%">

			<p>4.8-7.4 Volts</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Operating Temperature Range</b></u></font></p>

			</td>

			<td width="60%">

			<p>-20 to +60Â°C</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Operating Speed (4.8V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>0.15sec/60Â° @ No Load</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Operating Speed (6.0V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>0.12sec/60Â° @ No Load</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Stall Torque (4.8V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>24.0 kg-cm</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Stall Torque (6.0V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>30.0 kg-cm</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Holding Torque (4.8V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>31.2 kg-cm @ 5Â° Deflection</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Holding Torque (6.0V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>39.0 kg-cm @ 5Â° Deflection</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Drain Current (4.8V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>3.0mA@ Idle and 300mA@ No Load Operating</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Drain Current (6.0V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>3.0mA@ Idle and 380mA@ No Load Operating</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Stall Current (4.8V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>4200mA</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Stall Current (6.0V)</b></u></font></p>

			</td>

			<td width="60%">

			<p>5200mA</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Dead Band Width</b></u></font></p>

			</td>

			<td width="60%">

			<p>2Âµsec</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Operating Angle</b></u></font></p>

			</td>

			<td width="60%">

			<p>90Â° One Side/Pulse Traveling 400Âµsec</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Direction</b></u></font></p>

			</td>

			<td width="60%">

			<p>Clockwise/Pulse Traveling 1500 to 1900Âµsec</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Motor Type</b></u></font></p>

			</td>

			<td width="60%">

			<p>Coreless Metal Brush</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Potentiometer Type</b></u></font></p>

			</td>

			<td width="60%">

			<p>6 Slider Indirect Drive</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Amplifer Type</b></u></font></p>

			</td>

			<td width="60%">

			<p>Digital Amplifier & Mosfet Driver</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Gears</b></u></font></p>

			</td>

			<td width="60%">

			<p>Titanium Gears</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Bearings</b></u></font></p>

			</td>

			<td width="60%">

			<p>Dual Ball Bearing</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Connector Wire Length</b></u></font></p>

			</td>

			<td width="60%">

			<p>300mm</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Connector Wire Gauge</b></u></font></p>

			</td>

			<td width="60%">

			<p>22AWG</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Connector Wire Stand Count</b></u></font></p>

			</td>

			<td width="60%">

			<p>60EA</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Dimension (mm)</b></u></font></p>

			</td>

			<td width="60%">

			<p>40x20x37</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Weight (g)</b></u></font></p>

			</td>

			<td width="60%">

			<p>62.0</p>

			</td>

		</tr>

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>350Â° Modifiable</b></u></font></p>

			</td>

			<td width="60%">

			<p>Yes</p>

			</td>

		</tr>

	</tbody>

</table>

So my question is-

1. Is there a way to save all the specs of differnet products from the same catergory into a CSV file, upload the CSV file to the webserver and add some codes below the description to extract the specs, form up the table for the specs and insert the data into the table.

2. Use this method to expand this mod into a compare products mod.

Or if anyone has any idea on how to keep the MySQL database small and yet is able to retain the specs table, do let me know.

Thanks in advance...

June 29, 2006

		<tr valign="top">

			<td width="40%">

			<p><font color="#0000ff"><u><b>Control System</b></u></font></p>

			</td>

			<td width="60%">

			<p>+Pluse Width Control 1500Âµsec Netural</p>

			</td>

		</tr>

To answer your first question first, creating such a module should be possible but this sounds like a pretty special custom mod so changing hosting plans might be cheaper :w00t:

Second that specs table is in serious need of some CSS love. You can strip that down to:

See the difference ?

This assumes you use put a id or class statement into the table head. That way you get "hooks" you can use for your CSS styling to style the individual cells.

And I beleive if you set your very first row to 40% and 60% that will force all the other cells into the same size. If not at worst you have to add back the width statements.

This should at least chop a lot of your extra code and you can do so much more with tables when you style them with CSS.

Cobos

<tr>

<td>Control System</td>

<td>+Pluse Width Control 1500Âµsec Netural</td>

</tr>

June 29, 2006

See the difference ?
This assumes you use put a id or class statement into the table head. That way you get "hooks" you can use for your CSS styling to style the individual cells.

And I beleive if you set your very first row to 40% and 60% that will force all the other cells into the same size. If not at worst you have to add back the width statements.

This should at least chop a lot of your extra code and you can do so much more with tables when you style them with CSS.

Cobos

thanks cobos.....will try to change it and try. anyone got any more ideas? i am totally nuts with web programmng...

really hope this mod will eventually evolve into a "compare your products mod"

Sign In

Functions in Description

Recommended Posts

Guest treecom

Link to comment

Share on other sites

Guest Cobos

Link to comment

Share on other sites

Guest treecom

Link to comment

Share on other sites

Join the conversation

Browse

Activity