MySQL Connection

[globalwin]

Hi people, can anyone tell me how I would connect to my DB, to a table called domains, and add data to it, then disconnect, the database is also called domains, and the user is root.

[Admin]

Roughly:

PHP Code:

<?php

$cid = mysql_connect('localhost', 'root', 'PASSWORD');
mysql_select_db('domains', $cid);

mysql_query('
    INSERT INTO domains
    SET field1 = "somestring", field2 = 14, field3 = "someotherstring
');

mysql_close($cid);

?>

[globalwin]

cheers,

[globalwin]

come to try it, but i failed , here is my code:

PHP Code:

<?php 

$cid = mysql_connect('localhost', 'root', ''); 
mysql_select_db('domains', $cid); 

mysql_query(' 
INSERT INTO domains 
SET field1 = "fname", field2 = "lname", field3 = "email", field4 = "domain", field5 = "length", field6 = "address"
'); 

mysql_close($cid); 

?>

and my form:

  <form action="db.php" method="post" enctype="multipart/form-data" name="domains" target="_self" class="bodytext" id="domains">
  <table width="525" border="0">
    <tr>
        <td>First Name:</td>
      <td><input type="text" name="fname" /></td>
    </tr>
    <tr>
        <td>Last Name:</td>
      <td><input type="text" name="lname" /></td>
    </tr>
    <tr>
        <td>Email Address:</td>
      <td><input type="text" name="email" /></td>
    </tr>
    <tr>
      <td>Domain Name:</td>
      <td><input type="text" name="domain" /></td>
    </tr>
    <tr> 
      <td><p>Registration Years:</p>
          </td>
      <td><input type="text" name="length" /></td>
    </tr>
	    <tr>
      <td valign="top">Mailing Address:</td>
      <td><textarea name="address" cols="40" rows="5"></textarea></td>
    </tr>
  </table>
    <p>* - All Fields Required</p>
    <p> 
    <input type="submit" name="Submit" value="Submit" />
    <input type="reset" name="Reset" value="Reset" />
  </p>
</form>

[Admin]

PHP Code:

<?php

$cid = mysql_connect('localhost', 'root', '');
mysql_select_db('domains', $cid);

$fields = array('fname', 'lname', 'email', 'domain', 'length', 'address');

$fieldlist = '';
foreach ($fields as $field) {
    if (!empty($fieldlist)) {
        $fieldlist .= ', ';
    }
    $fieldlist .= "$field = '".addslashes($_POST["$field"])."'";
}

mysql_query("
INSERT INTO domains
SET $fieldlist
");

mysql_close($cid);

?>

[globalwin]

YAY, data got inserted into the DB, it was all 0 though, can anyone please tell me what type of field i want because I am using TINYINTs at the min and it doesnt work. Cheers Chen.

[Admin]

You need to use VARCHAR (or CHAR) for string types, and TINYINT / SMALLINT / INT for integers.

[globalwin]

ok, getting there and thanx for the help, now, as before i could see 0's, not MySQL Front says the data is there, but I cant view it.

[Admin]

You will need to enter the data again.

[globalwin]

hehe , is there anyway I can make the page display a redirection note like vB and then take them back to my homepage? Thanks for the intense help!