Posted By

antpaw on 08/20/08

Tagged

mysql
php

Versions (?)

Last Edited at 08/20/08 04:14pm

Statistics

Viewed 825 times

Favorited by 3 user(s)

Related snippets

MySQL connection with PHP

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
mysql_connect("localhost","root","asdf") or die (mysql_error());
mysql_select_db("DB") or die (mysql_error());
 
$result = mysql_query('SELECT * FROM tabellename') or die (mysql_error());
 
while($entry = mysql_fetch_assoc($result)){
$entry['headline']
}
 
mysql_free_result($result);
 
 
 
$entry= "INSERT INTO tabellename (feld1, feld2) VALUES ('111111s', '2222222s');";
$init = mysql_query($entry);
 
$change = "UPDATE blog Set tag = 'Cinema 4D' WHERE id = '2'";
$update = mysql_query($change);
?>