Dakle fajlovi se poyivaju sledećim redosledom:
mySqlControlPanel.php >
createTableGUI.php>
RcreateTable.php>
createTable.php>
functions.php
============
functions.php
Code:
...
[b]function IzaberiBazu($dbName,$connection)[/b]
{//ovde selectujemo bazu
$MsgSelectSucces='Baza uspešno selektovana.\n';
$ErrSelectDB='Greška u selektovanju baze: \n';
if (mysql_select_db($dbName,$connection)){
echo MsgSelectSucces;
return true;
}else{
echo $ErrSelectDB;
return false;
}
}
...
...
[b]function IzaberiBazu($dbName,$connection)[/b]
{//ovde selectujemo bazu
$MsgSelectSucces='Baza uspešno selektovana.\n';
$ErrSelectDB='Greška u selektovanju baze: \n';
if (mysql_select_db($dbName,$connection)){
echo MsgSelectSucces;
return true;
}else{
echo $ErrSelectDB;
return false;
}
}
...
createTableGUI.php dole je citav
==========================================
Code:
...
<form id="form1" name="form1" method="post" action="RcreateTable.php">
...
...
<form id="form1" name="form1" method="post" action="RcreateTable.php">
...
RcreateTable.php
================================
Code:
...
<body>
<?php
include_once("naslov.php");
include_once("linkovi.php");
?>
<table width="786" height="269" border="0">
<tr>
<td><?php include_once("konektujGUI.php"); ?></td>
<td><?php include_once("createDbGUI.php");?>;</td>
</tr>
<tr>
<td>[b]<?php include_once("createTable.php"); ?>;[/b]</td>
<td><?php include_once("insertRowGUI.php");?></td>
</tr>
<tr>
<td><?php aaa?>;</td>
<td><?php include_once("SqlQueryGUI.php")?></td>
</tr>
</table>
</body>
..
...
<body>
<?php
include_once("naslov.php");
include_once("linkovi.php");
?>
<table width="786" height="269" border="0">
<tr>
<td><?php include_once("konektujGUI.php"); ?></td>
<td><?php include_once("createDbGUI.php");?>;</td>
</tr>
<tr>
<td>[b]<?php include_once("createTable.php"); ?>;[/b]</td>
<td><?php include_once("insertRowGUI.php");?></td>
</tr>
<tr>
<td><?php aaa?>;</td>
<td><?php include_once("SqlQueryGUI.php")?></td>
</tr>
</table>
</body>
..
createTable.php
===============
Code:
<?php
require_once("funkcije.php");
$sql = new mySql();
/* variable za konektovanje na sql server : */
/*$hostName=$_POST['textfieldHostName'];
$dbUserName=$_POST['textfieldUserName'];
$dbUserPass=$_POST['textfieldUserPass'];*/
/* konektovanje bez prenosa*/
$hostName=$_POST['hiddenField'];
$dbUserName=$_POST['hiddenField2'];
$dbUserPass=$_POST['hiddenField3'];
echo "paarmetri:".$hostName.$dbUserName.$dbUserPass;
$connection=$sql->Konektuj($hostName,$dbUserName,$dbUserPass);
/* selektovanje baze*/
$dbName=$_POST['textfieldDbName'];
if([b]$sql->IzaberiBazu($dbName,$connection)[/b]){ //ako uspešno izabrana baza
/* messages : */
$MsgTableCreated="Tabela ".$tName.' kreirana uspješno \n';
$ErrTableCreate='Greška u kreiranju tabele: ' . mysql_error() . ' ';
/* parametri za kreiranje tabele */
$tName=$_POST['textfieldTableName'];
/* kreiram query
sintaksa:
CREATE TABLE <IME TABELE> (<IME KOLONE> <TIP PODATAKA> [(<VELICINA>)] <OGRANICENJE KOLONE>, ... druge kolone)
*/
$query = "CREATE TABLE ".tName."(";
for($i=1;$i<=$_POST["textFieldNUM"];$i++){
$query.=",";
$query.=$_POST["textfield".$i];
};
$query.=")";
/* kreiranje tabele */
if ($sql->Upit($query,$connection)){
echo $MsgTableCreated;
}else{
echo $ErrTableCreate;
};
};/* if $sql()->IzaberiBazu*/
<?php
require_once("funkcije.php");
$sql = new mySql();
/* variable za konektovanje na sql server : */
/*$hostName=$_POST['textfieldHostName'];
$dbUserName=$_POST['textfieldUserName'];
$dbUserPass=$_POST['textfieldUserPass'];*/
/* konektovanje bez prenosa*/
$hostName=$_POST['hiddenField'];
$dbUserName=$_POST['hiddenField2'];
$dbUserPass=$_POST['hiddenField3'];
echo "paarmetri:".$hostName.$dbUserName.$dbUserPass;
$connection=$sql->Konektuj($hostName,$dbUserName,$dbUserPass);
/* selektovanje baze*/
$dbName=$_POST['textfieldDbName'];
if([b]$sql->IzaberiBazu($dbName,$connection)[/b]){ //ako uspešno izabrana baza
/* messages : */
$MsgTableCreated="Tabela ".$tName.' kreirana uspješno \n';
$ErrTableCreate='Greška u kreiranju tabele: ' . mysql_error() . ' ';
/* parametri za kreiranje tabele */
$tName=$_POST['textfieldTableName'];
/* kreiram query
sintaksa:
CREATE TABLE <IME TABELE> (<IME KOLONE> <TIP PODATAKA> [(<VELICINA>)] <OGRANICENJE KOLONE>, ... druge kolone)
*/
$query = "CREATE TABLE ".tName."(";
for($i=1;$i<=$_POST["textFieldNUM"];$i++){
$query.=",";
$query.=$_POST["textfield".$i];
};
$query.=")";
/* kreiranje tabele */
if ($sql->Upit($query,$connection)){
echo $MsgTableCreated;
}else{
echo $ErrTableCreate;
};
};/* if $sql()->IzaberiBazu*/
Da pojasnim malo greska mi se javlja pri selektovanju baze znaci mysql_select_db().
Podebljao sam to u kodu.Pri tome znam sigurno da je konekcija uspešno izvršena(funkcija Konektuj kaže u poruci),jer i također znam da postoji baza sa imenom koje se selektuje(kada poklušam da je kreiram pomoću jednog drugog .php-a ,javi se mysql_error()="..cant create..database exist blabla..").Šta bi bio problem?
evo za svaki slučaj i createTableGUI.php:
Code:
<body>
<fieldset>
<legend><strong>Kreiranje tabele u bazi</strong></legend>
<p>
<?php //da selektujem bazu
require_once("funkcije.php");
$sql = new mySql();
?>
</p>
<form id="form3" name="form3" method="post" action="mySqlControlPanel.php">
<label>izaberi bazu:
<input name="textfieldDbName" type="text" id="textfieldDbName" />
<br />
ime tabele
<input name="textfieldTableName" type="text" id="textfieldTableName" />
</label>
<br />
izmeni brojKolona:
<label>
<input name="textfieldNUM" type="text" id="textfieldNUM" value="<?php
if(isset($_POST["textfieldNUM"])){
echo $_POST["textfieldNUM"];
}else{
echo 1;
};
?>" size="4"/>
</label>
<label>
<input type="submit" name="Submit3" value="Podesi broj kolona" />
</label>
</form>
<p>//trebaće mi opcija za selektovanje baze! </p>
<form id="form1" name="form1" method="post" action="RcreateTable.php">
<p>Polja tabele unositi sledećom sintaksom:<br />
<IME KOLONE> <TIP PODATAKA> [(<VELICINA>)] <OGRANICENJE KOLONE> </p>
<p><?php
if (isset($_POST["textfieldNUM"])){
$n=$_POST["textfieldNUM"];
}else{
$n=1;
};
for ($i=1;$i<=$n;$i++){
echo "<input name=\"textfield".$i."\" type=\"text\" id=\"textfield".$i."\" /> ";
};//ispisati ovde sva text polja koja treba da se insertuju
?>
<input type="hidden" name="hiddenField" value="<?php
if(isset($_POST['textfieldHostName'])){
echo $_POST['textfieldHostName'];
}else{
echo "localhost";
};
?>"/>
<input type="hidden" name="hiddenField2" value="<?php
if(isset($_POST['textfieldUserName'])){
echo $_POST['textfieldUserName'];
}else{
echo "root";
};
?>"/>
<input type="hidden" name="hiddenField3" value="<?php
if(isset($_POST['textfieldUserPass'])){
echo $_POST['textfieldUserPass'];
}else{
echo "";
};
?>"/>
<input name="hiddenFielddbName" type="hidden" id="hiddenFielddbName" value="<?php
if(isset($_POST['textfieldDbName'])){
echo $_POST['textfieldDbName'];
}else{
echo "Baza1";
};
?>"/>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Kreiraj tabelu" />
</label>
</p>
</form>
<p> </p>
</fieldset>
</body>
<body>
<fieldset>
<legend><strong>Kreiranje tabele u bazi</strong></legend>
<p>
<?php //da selektujem bazu
require_once("funkcije.php");
$sql = new mySql();
?>
</p>
<form id="form3" name="form3" method="post" action="mySqlControlPanel.php">
<label>izaberi bazu:
<input name="textfieldDbName" type="text" id="textfieldDbName" />
<br />
ime tabele
<input name="textfieldTableName" type="text" id="textfieldTableName" />
</label>
<br />
izmeni brojKolona:
<label>
<input name="textfieldNUM" type="text" id="textfieldNUM" value="<?php
if(isset($_POST["textfieldNUM"])){
echo $_POST["textfieldNUM"];
}else{
echo 1;
};
?>" size="4"/>
</label>
<label>
<input type="submit" name="Submit3" value="Podesi broj kolona" />
</label>
</form>
<p>//trebaće mi opcija za selektovanje baze! </p>
<form id="form1" name="form1" method="post" action="RcreateTable.php">
<p>Polja tabele unositi sledećom sintaksom:<br />
<IME KOLONE> <TIP PODATAKA> [(<VELICINA>)] <OGRANICENJE KOLONE> </p>
<p><?php
if (isset($_POST["textfieldNUM"])){
$n=$_POST["textfieldNUM"];
}else{
$n=1;
};
for ($i=1;$i<=$n;$i++){
echo "<input name=\"textfield".$i."\" type=\"text\" id=\"textfield".$i."\" /> ";
};//ispisati ovde sva text polja koja treba da se insertuju
?>
<input type="hidden" name="hiddenField" value="<?php
if(isset($_POST['textfieldHostName'])){
echo $_POST['textfieldHostName'];
}else{
echo "localhost";
};
?>"/>
<input type="hidden" name="hiddenField2" value="<?php
if(isset($_POST['textfieldUserName'])){
echo $_POST['textfieldUserName'];
}else{
echo "root";
};
?>"/>
<input type="hidden" name="hiddenField3" value="<?php
if(isset($_POST['textfieldUserPass'])){
echo $_POST['textfieldUserPass'];
}else{
echo "";
};
?>"/>
<input name="hiddenFielddbName" type="hidden" id="hiddenFielddbName" value="<?php
if(isset($_POST['textfieldDbName'])){
echo $_POST['textfieldDbName'];
}else{
echo "Baza1";
};
?>"/>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Kreiraj tabelu" />
</label>
</p>
</form>
<p> </p>
</fieldset>
</body>
=============================
mySqlControlPanel.php
Code:
<body>
<p>
<?php
include_once("naslov.php");
include_once("linkovi.php");
?>
</p>
<table width="786" height="269" border="0">
<tr>
<td><?php include_once("konektujGUI.php"); ?></td>
<td><?php include_once("createDbGUI.php"); ?>;</td>
</tr>
<tr>
<td><?php include_once("createTableGUI.php"); ?>;</td>
<td><?php include_once("insertRowGUI.php");?></td>
</tr>
<tr>
<td><?php aaa?>;</td>
<td><?php include_once("SqlQueryGUI.php")?></td>
</tr>
</table>
</body>
<body>
<p>
<?php
include_once("naslov.php");
include_once("linkovi.php");
?>
</p>
<table width="786" height="269" border="0">
<tr>
<td><?php include_once("konektujGUI.php"); ?></td>
<td><?php include_once("createDbGUI.php"); ?>;</td>
</tr>
<tr>
<td><?php include_once("createTableGUI.php"); ?>;</td>
<td><?php include_once("insertRowGUI.php");?></td>
</tr>
<tr>
<td><?php aaa?>;</td>
<td><?php include_once("SqlQueryGUI.php")?></td>
</tr>
</table>
</body>
[Ovu poruku je menjao damso dana 08.02.2006. u 14:57 GMT+1]
www.eden.rs
Izdavač duhovne i filozofske literature
Izdavač duhovne i filozofske literature