8791 sujets

Développement web côté serveur, CMS

Creer une base de donnees a partir d'un formulaire

Bonjour a tous. tout d'abord desole pour pour les accents manquant, je suis sur un qwerty .

Donc voila mon soucis qui en realite je suis sur est tres simple a resoudre. J'ai cree un petit formulaire client que voici :


<h3>Home buyers</h3>	
<form id="subscribe-form" method="post" action="home_buyers.php">


<fieldset>
	<br/><br/>
	
		<div id="frame1">
      <span class="subtitle">  Name </span>
        <input type="text" id="pseudo" name="name" size="37" maxlength="100" />
   

	
		<span class="subtitle">Address </span>
		<input type="text" id="address" name="address" size="37" maxlength="100" />
	

		<span class="subtitle">E-mail </span>
		<input type="text" id="email" name="email" size="37" maxlength="100" />


		<span class="subtitle">Contact telephone </span>
		<input type="text" id="phone" name="phone" size="37" maxlength="100" />
	

	
	</div>
	
	<div class="frame2">
		<span class="subtitle">The aspect that interests me most is :</span><br/>
		<select name="interest">
    <option value="Green lifestyles">Green lifestyles</option>
    <option value="Stylish and quality design">Stylish and quality design</option>
    <option value="Community lifestyle">Community lifestyle</option>
    <option value="Competitive pricing">Competitive pricing</option>
	<option value="Customer service excellence and build quality">Customer service excellence and build quality</option>
	<option value="Choice and Participation">Choice and Participation</option>
	<option value="Location">Location</option>
</select><br/><br/><br/>
	
	
		<span class="subtitle">Property Requirements :</span><br/><br/>
		
		<table><tr><td>
<input type="checkbox" name="Number of bedrooms"/> Number of bedrooms </td> <td><input type="checkbox" name="Number of reception rooms  "/> Number of reception rooms</td></tr>
<tr><td>
<input type="checkbox" name="Size of flat (sq. ft. or sq. m)"/> Size of flat (sq. ft. or sq. m)</td><td> <input type="checkbox" name="External space as balcony or garden"/> External space as balcony or garden</td></tr>
<tr><td>
<input type="checkbox" name="Kitchen requirements"/> Kitchen requirements</td><td> <input type="checkbox" name="Bathroom requirements"/> Bathroom requirements  </td></tr>
<tr><td>
<input type="checkbox" name="Floor finish "/> Floor finish</td><td> <input type="checkbox" name="Storage space"/> Storage space</td></tr>
<tr><td>
<input type="checkbox" name="Orientation west facing, east facing etc."/> Orientation west facing, east facing etc</td><td> <input type="checkbox" name="Amount of natural light/ size of windows"/> Amount of natural light/ size of windows</td></tr>
<tr><td>
<input type="checkbox" name="Storey i.e. ground floor, 1st floor, 6th floor etc"/> Storey i.e. ground floor, 1st floor, 6th floor etc</td><td> <input type="checkbox" name="Specification options"/> Specification options </td></tr>
<tr><td>
<input type="checkbox" name="Broadband/ IT/ TV etc"/> Broadband/ IT/ TV etc</td><td> <input type="checkbox" name="Walking distance to public transport"/> Walking distance to public transport </td></tr>
<tr><td>
<input type="checkbox" name="Local facilities/ shops"/> Local facilities/ shops </td><td> <input type="checkbox" name="Schools"/> Schools</td></tr>
</table><br/>
	Other
		<input type="text" id="other" name="other" size="20" maxlength="100"/> <br/><br/><br/>
		
		
		<span class="subtitle"> Community facilities - Interested in: </span><br/><br/> 
		
	<table><tr><td>
	<input type="checkbox" name="Car club and mobility card"/> Car club and mobility card </td> <td> <input type="checkbox" name="Organic food club"/> Organic food club</td></tr>
	
<tr><td>
	<input type="checkbox" name="Time banking"/> Time banking </td> <td> <input type="checkbox" name="Shared communal facilities, such as bar, lounge etc"/> Shared communal facilities, such as bar, lounge etc </td></tr>	
	 
<tr><td>
	<input type="checkbox" name="Mini-allotments"/> Mini-allotments </td> <td><input type="checkbox" name="Community cinema club"/> Community cinema club </td></tr>		
	</table><br/><br/><br/>

		Price Range	<select name="price">
    <option value="1 bed flat">1 bed flat</option>
    <option value="2 bed flat">2 bed flat</option>
    <option value="3 bed flat">3 bed flat</option>
    <option value="Studio">Studio</option>
</select>
		<br/><br/><br/>
		
		
	<input type="submit" name="home_buyers" value="send" /> <input type="reset"/>


Il va servir a cree une base de donnees client pour ma boite. Jai cree les tables sur mysql et j'aimerais maintenant recuperer les informations que les clients vont entrer dans le formulaire. J'espere que le sujet n'a pas ete aborde 10 000 fois, si c le cas dsl. Donc si quelqu'un pouvait me venir en aide. merci d'avance Smiley ravi
Sujet clos
Aller à