Php script to work with sql database.

[Casteloes]

Does anyone knows a php script where I can change and manage a sql database?
I want to create the database (if the script don't do that there is no problem) and then add new records to it.

 

[pixelbypixel]

I can help if you like.

Send me a PM of what you want doing, and I will see if i have time.

I made php for metal-db.com -> is this the kinda thing your looking for? where users/you can add data to a database, or remove/edit it?

 

[GamingMedley]

mysql_query("THE SQL COMMAND")

http://php.net/mysql_query

 

[averge]

I can help you too, just send me pm with more informations...

 

[nasaboy007]

Don't bother paying anybody to do it, just go install PHPMyAdmin on your server - http://www.phpmyadmin.net/home_page/index.php


This is assuming YOU want to make the database edits, and not your users or something.

 

[averge]

I didn't want to pay for it :/

 

[Casteloes]

NVD in my case is only one user to edit the database.
Is can be something like you sow changing the fields of curse.

averge e NVD i will try to explain what i want.
I want a database about art (paintings, sculptures and more).
My mais problem is to do it in a visual way. I can make the database from phpmyadmin but when the user add add records to it it show be something like that:

It have the field name and then the space to write.

I can't find nothing to do it.

This explanation help to understand what i want?

I will send pm too.

 

[pixelbypixel]

Send me the name of the columns you have in your database and i'll code the form for you if thats all you require.

 

[nasaboy007]

If you just go to the "Insert" tab in PHPMyAdmin (assuming your column names are semidescriptive, or you can just tell the person inputting the data what each field is.

http://easycaptures.com/fs/uploaded/104/thumbs/9683438085_b.jpg


See the Insert tab selected? isn't this basically what you want? why reinvent the wheel?

 

[pixelbypixel]

He did state he wants a GUI to do it with on a webpage, instead of having to log into the back end.

Just PM me the column names and I'll write the php, then you will just have to add the db name and user/pass into the variables, I'll let you know where

 

[biztiger]

First connect the mysql database
http://in2.php.net/manual/en/function.mysql-connect.php

Use mysql_create_db for creating database.
http://in2.php.net/function.mysql_create_db

Then select the db, using mysql_select_db
http://in2.php.net/manual/en/function.mysql-select-db.php

After then just run sql queries using
http://php.net/mysql_query

Hope it solves your problem

 

[FrozenNova]

can you post the column names in the database & HTML for the form you wish to use and I'll quickly knock up a script for you.

Regards

 

[pixelbypixel]

Removed code.

 

[FrozenNova]

instead of defining all of the variables from the get use a foreach loop to define array as => value saves a few lines of coding

 

[Casteloes]

I told him to post the code I gave him for help, but no replies.

I contact averge by private message and that's why i don't put the code in topic.

 

[pixelbypixel]

Removed the code for you then, was just trying to get it fixed for you. nevermind.

FrozenNova, i said it was long winded to prevent errors, and so it was easy to follow for Casteloes.

 

[Casteloes]

Removed the code for you then, was just trying to get it fixed for you. nevermind.

FrozenNova, i said it was long winded to prevent errors, and so it was easy to follow for Casteloes.

I thanks you to trying to help me. Don't need to remove the code.

 

[pixelbypixel]

here it is again then:

The code:

// PUT THE BELOW INTO insert.php

<?php

$con = mysql_connect("localhost","root","teste");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$v1=$_GET["1"];
$v2=$_GET["2"];
$v3=$_GET["3"];
$v4=$_GET["4"];
$v5=$_GET["5"];
$v6=$_GET["6"];
$v7=$_GET["7"];
$v8=$_GET["8"];
$v9=$_GET["9"];
$v9b=$_GET["9b"];
$v10=$_GET["10"];
$v11=$_GET["11"];
$v12=$_GET["12"];
$v13=$_GET["13"];
$v14=$_GET["14"];
$v15=$_GET["15"];
$v16=$_GET["16"];
$v17=$_GET["17"];
$v18=$_GET["18"];
$v19=$_GET["19"];
$v20=$_GET["20"];
$v21=$_GET["21"];
$v22=$_GET["22"];
$v23=$_GET["23"];
$v24=$_GET["24"];
$v25=$_GET["25"];
$v26=$_GET["26"];
$v27=$_GET["27"];
$v28=$_GET["28"];
$v29=$_GET["29"];
$v30=$_GET["30"];
$v31=$_GET["31"];
$date=date("F jS Y");

mysql_select_db("severvouga", $con);

mysql_query("INSERT INTO table1( Categoria, SubCategoria , Denominaçao, Identificacao, Localizacao, Enquadramento, Datacao, Autoria, Escola, Producao, Inscricoes, Iconografia, Materia, Suporte, Tecnica, Largura, Altura, Comprimento, Peso, Funcao, Descricao, Estado, Proveniencia, Propriedade, Proteccao, Incorporacao, Imagem, Historial, Bibliografia, Exposicoes, Observacoes, Preenchido, Data)
VALUES ('$v1', '$v2', '$v3', '$v4', '$v5', '$v6', '$v7', '$v8', '$v9', '$v9b', '$v10', '$v11', '$v12', '$v13', '$v14', '$v15', '$v16', '$v17', '$v18', '$v19', '$v20', '$v21', '$v22', '$v23', '$v24', '$v25', '$v26', '$v27', '$v28', '$v29', '$v30', '$v31', '$date')");

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

header("Location: form.html");

mysql_close($con);

?>

Form:

<!-- PUT THIS INTO form.html -->

<html>
<body>

<form action="insert.php" method="get">
<table>
<tr><td width="200" align="right">Categoria:</td><td> <input type="text" name="1" /></td></tr>
<tr><td width="200" align="right">Sub-Categoria:</td><td> <input type="text" name="2" /></td></tr>
<tr><td width="200" align="right">Denominação:</td><td> <input type="text" name="3" /></td></tr>
<tr><td width="200" align="right">Identificação:</td><td> <input type="text" name="4" /></td></tr>
<tr><td width="200" align="right">Localização:</td><td> <input type="text" name="5" /></td></tr>
<tr><td width="200" align="right">Enquadramento:</td><td> <input type="text" name="6" /></td></tr>
<tr><td width="200" align="right">Datação:</td><td> <input type="text" name="7" /></td></tr>
<tr><td width="200" align="right">Autoria:</td><td> <input type="text" name="8" /></td></tr>
<tr><td width="200" align="right">Escola/Estilo:</td><td> <input type="text" name="9" /></td></tr>
<tr><td width="200" align="right">Produção:</td><td> <input type="text" name="9b" /></td></tr>
<tr><td width="200" align="right">Marcas e Inscrições:</td><td> <input type="text" name="10" /></td></tr>
<tr><td width="200" align="right">Iconografia:</td><td> <input type="text" name="11" /></td></tr>
<tr><td width="200" align="right">Matéria:</td><td> <input type="text" name="12" /></td></tr>
<tr><td width="200" align="right">Suporte:</td><td> <input type="text" name="13" /></td></tr>
<tr><td width="200" align="right">Técnica:</td><td> <input type="text" name="14" /></td></tr>
<tr><td width="200" align="right">Dimensões Largura:</td><td> <input type="text" name="15" /></td></tr>
<tr><td width="200" align="right">Dimensões Altura:</td><td> <input type="text" name="16" /></td></tr>
<tr><td width="200" align="right">Dimensões Comprimento:</td><td> <input type="text" name="17" /></td></tr>
<tr><td width="200" align="right">Peso:</td><td> <input type="text" name="18" /></td></tr>
<tr><td width="200" align="right">Função Inicial/Alterações:</td><td> <input type="text" name="19" /></td></tr>
<tr><td width="200" align="right">Descrição:</td><td> <input type="text" name="20" /></td></tr>
<tr><td width="200" align="right">Estado de Conservação:</td><td> <input type="text" name="21" /></td></tr>
<tr><td width="200" align="right">Proveniência:</td><td> <input type="text" name="22" /></td></tr>
<tr><td width="200" align="right">Propriedade:</td><td> <input type="text" name="23" /></td></tr>
<tr><td width="200" align="right">Protecção:</td><td> <input type="text" name="24" /></td></tr>
<tr><td width="200" align="right">Incorporação:</td><td> <input type="text" name="25" /></td></tr>
<tr><td width="200" align="right">Imagem:</td><td> <input type="text" name="26" /></td></tr>
<tr><td width="200" align="right">Historial:</td><td> <input type="text" name="27" /></td></tr>
<tr><td width="200" align="right">Bibliografia:</td><td> <input type="text" name="28" /></td></tr>
<tr><td width="200" align="right">Exposições:</td><td> <input type="text" name="29" /></td></tr>
<tr><td width="200" align="right">Observações:</td><td> <input type="text" name="30" /></td></tr>
<tr><td width="200" align="right">Preenchido por:</td><td> <input type="text" name="31" /></td></tr>
</table>
<center><input type="submit" /></center>
</form>

</body>
</html>

The SELECT query I wrote him works though:

<?php

$con = mysql_connect("localhost","****","****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}


mysql_select_db("severvouga", $con);

$result = mysql_query("SELECT * FROM table1");

$i=1;

while($row = mysql_fetch_array($result))
  {
  echo "<b><u>Entry Number: ".$i."<br />";
  echo $row['Categoria'];
  echo "<br />";
  echo $row['SubCategoria'];
  echo "<br />";
  echo $row['Denominaçao'];
  echo "<br />";
  echo $row['Identificacao'];
  echo "<br />";
  echo $row['Localizacao'];
  echo "<br />";
  echo $row['Enquadramento'];
  echo "<br /> etc... <br /><br />";

  }

mysql_close($con);
?>