inserting data in db ?

[ajdegans]

Question... how do i make a script, lets say a weblog, that creates a database and tables with column from a php file?

imagine it like a install file 🙂

Thanks in advance

😃

[nemonoman]

you'll need a script that lets the user log into mysql with proper privileges:

$result=mysql_query("CREATE DATABASE myDB");
$result=mysql_query("use myDB");
$result=mysql_query("CREATE TABLE sequence (id INT)");
$result=mysql_query("INSERT INTO sequence VALUES (0)");

etc...

[ajdegans]

yup thanks 🙂 for the table insertion i use ...

<?php
include ("connect.php");

$install = "
CREATE TABLE werknemers
  (voornaam varchar(15),
  achternaam varchar(20),
  leeftijd varchar(3),
  adres varchar(30),
  woonplaats varchar(20),
  land varchar(20))
";
mysql_query($install) or die("Could not install table");


?>
[/PHp]

thanks for directions:):D