PHP & MySQL Issue!
am 13.07.2007 03:41:48 von Austin C
------=_Part_28487_7696839.1184290908863
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hello everyone, im trying to use PHP to create 2 tables in a database and
populate them with tables, however, it just wont work. Here is my full code:
$hostname = $_GET['hostname'];
$dbname = $_GET['dbname'];
$dbusername = $_GET['dbusername'];
$dbpassword = $_GET['dbpassword'];
$dbprefix = $_GET['dbprefix'];
echo "
Install- Processing Database Info . . . . .
";
$cxn = mysqli_connect($hostname,$dbusername,$dbpassword,$dbname)
or die ("Basic Library System could not connect to the database you
specified. Please go back and make sure the information you submitted is
correct.");
$file = '../config.php';
$fh = fopen($file, 'w') or die('Failed to open config.php file');
fwrite($fh, '
$dbname="'.$dbname.'";
$dbusername="'.$dbusername.'";
$dbpassword="'.$dbpassword.'";
$dbprefix="'.$dbprefix.'"; ?>') or die('Could not write to config.php');
fclose($fh);
mysqli_select_db($cxn,$dbname)
or die ("Could not connect to the database you specified. Please go
back and make sure you entered the correct database.");
mysqli_select_db($cxn,$dbname);
$sql = "CREATE TABLE ".$dbprefix."_circulation
(
title varchar(100),
author varchar(100),
pubdate varchar(100),
genre varchar(100),
medium varchar(100),
price varchar(100),
id int(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id)
)";
mysqli_select_db($cxn,$dbname);
$sql = "CREATE TABLE ".$dbprefix."_holder
(
space varchar(100)
)";
$query = mysqli_query($cxn,$sql);
if(!$query){
echo "Basic Library System was unable to submit the information to the
database. Please make sure you specified correct information.";
}else{
echo "Successfully created table. Do something here";
}
mysqli_close($cxn);
?>
----------------------------------------------
Visit galacticwebdesigns.com for tutorials and more!
------=_Part_28487_7696839.1184290908863--
Re: PHP & MySQL Issue!
am 13.07.2007 04:33:07 von bedul
------=_NextPart_000_005B_01C7C530.D1BC9E50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: base64
DQotLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIA0KRnJvbTogIkF1c3Rp biBDIiA8Z2FsYWN0
aWNuZW9AZ21haWwuY29tPg0KVG86IDxwaHAtZGJAbGlzdHMucGhwLm5ldD4N ClNlbnQ6IEZyaWRh
eSwgSnVseSAxMywgMjAwNyA4OjQxIEFNDQpTdWJqZWN0OiBbUEhQLURCXSBQ SFAgJiBNeVNRTCBJ
c3N1ZSENCg0KDQo+IEhlbGxvIGV2ZXJ5b25lLCBpbSB0cnlpbmcgdG8gdXNl IFBIUCB0byBjcmVh
dGUgMiB0YWJsZXMgaW4gYSBkYXRhYmFzZSBhbmQNCj4gcG9wdWxhdGUgdGhl bSB3aXRoIHRhYmxl
cywgaG93ZXZlciwgaXQganVzdCB3b250IHdvcmsuIEhlcmUgaXMgbXkgZnVs bCBjb2RlOg0KPiAN
Cj4gDQo+IDw/cGhwDQo+ICRob3N0bmFtZSA9ICRfR0VUWydob3N0bmFtZSdd Ow0KPiAkZGJuYW1l
ID0gJF9HRVRbJ2RibmFtZSddOw0KPiAkZGJ1c2VybmFtZSA9ICRfR0VUWydk YnVzZXJuYW1lJ107
DQo+ICRkYnBhc3N3b3JkID0gJF9HRVRbJ2RicGFzc3dvcmQnXTsNCj4gJGRi cHJlZml4ID0gJF9H
RVRbJ2RicHJlZml4J107DQo+IA0KPiBlY2hvICI8Y2VudGVyPjxicj48Yj5J bnN0YWxsLSBQcm9j
ZXNzaW5nIERhdGFiYXNlIEluZm8gLiAuIC4gLiAuPC9iPg0KPiA8cD4NCj4g PHA+IjsNCj4gDQo+
ICRjeG4gPSBteXNxbGlfY29ubmVjdCgkaG9zdG5hbWUsJGRidXNlcm5hbWUs JGRicGFzc3dvcmQs
JGRibmFtZSkNCj4gICAgICAgIG9yIGRpZSAoIkJhc2ljIExpYnJhcnkgU3lz dGVtIGNvdWxkIG5v
dCBjb25uZWN0IHRvIHRoZSBkYXRhYmFzZSB5b3UNCj4gc3BlY2lmaWVkLiBQ bGVhc2UgZ28gYmFj
ayBhbmQgbWFrZSBzdXJlIHRoZSBpbmZvcm1hdGlvbiB5b3Ugc3VibWl0dGVk IGlzDQo+IGNvcnJl
Y3QuIik7DQo+IA0KPiAkZmlsZSA9ICcuLi9jb25maWcucGhwJzsNCj4gDQo+ ICRmaCA9IGZvcGVu
KCRmaWxlLCAndycpIG9yIGRpZSgnRmFpbGVkIHRvIG9wZW4gY29uZmlnLnBo cCBmaWxlJyk7DQo+
IA0KPiBmd3JpdGUoJGZoLCAnPD9waHAgJGhvc3RuYW1lPSInLiRob3N0bmFt ZS4nIjsNCj4gJGRi
bmFtZT0iJy4kZGJuYW1lLiciOw0KPiAkZGJ1c2VybmFtZT0iJy4kZGJ1c2Vy bmFtZS4nIjsNCj4g
JGRicGFzc3dvcmQ9IicuJGRicGFzc3dvcmQuJyI7DQo+ICRkYnByZWZpeD0i Jy4kZGJwcmVmaXgu
JyI7ID8+Jykgb3IgZGllKCdDb3VsZCBub3Qgd3JpdGUgdG8gY29uZmlnLnBo cCcpOw0KPiANCj4g
ZmNsb3NlKCRmaCk7DQo+IA0KPiBteXNxbGlfc2VsZWN0X2RiKCRjeG4sJGRi bmFtZSkNCg0KYXJl
IHRoaXMgc2hvdWxkIGJlDQpteXNxbGlfc2VsZWN0X2RiKCRkYm5hbWUsICRj eG4pID8/Pw0KYW5k
IHRoZSByZXN0IHNlZW0gbWlzcyBwbGFjZSBpbiB0aGUgZnVuY3Rpb24NCg0K DQo+ICAgICAgIG9y
IGRpZSAoIkNvdWxkIG5vdCBjb25uZWN0IHRvIHRoZSBkYXRhYmFzZSB5b3Ug c3BlY2lmaWVkLiBQ
bGVhc2UgZ28NCj4gYmFjayBhbmQgbWFrZSBzdXJlIHlvdSBlbnRlcmVkIHRo ZSBjb3JyZWN0IGRh
dGFiYXNlLiIpOw0KPiANCj4gbXlzcWxpX3NlbGVjdF9kYigkY3huLCRkYm5h bWUpOw0KPiAkc3Fs
ID0gIkNSRUFURSBUQUJMRSAiLiRkYnByZWZpeC4iX2NpcmN1bGF0aW9uDQo+ ICgNCj4gdGl0bGUg
dmFyY2hhcigxMDApLA0KPiBhdXRob3IgdmFyY2hhcigxMDApLA0KPiBwdWJk YXRlIHZhcmNoYXIo
MTAwKSwNCj4gZ2VucmUgdmFyY2hhcigxMDApLA0KPiBtZWRpdW0gdmFyY2hh cigxMDApLA0KPiBw
cmljZSB2YXJjaGFyKDEwMCksDQo+IGlkIGludCgyMCkgTk9UIE5VTEwgQVVU T19JTkNSRU1FTlQs
DQo+IFBSSU1BUlkgS0VZKGlkKQ0KPiApIjsNCj4gDQo+IG15c3FsaV9zZWxl Y3RfZGIoJGN4biwk
ZGJuYW1lKTsNCj4gJHNxbCA9ICJDUkVBVEUgVEFCTEUgIi4kZGJwcmVmaXgu Il9ob2xkZXINCj4g
KA0KPiBzcGFjZSB2YXJjaGFyKDEwMCkNCj4gKSI7DQo+IA0KPiAkcXVlcnkg PSBteXNxbGlfcXVl
cnkoJGN4biwkc3FsKTsNCj4gaWYoISRxdWVyeSl7DQo+IGVjaG8gIkJhc2lj IExpYnJhcnkgU3lz
dGVtIHdhcyB1bmFibGUgdG8gc3VibWl0IHRoZSBpbmZvcm1hdGlvbiB0byB0 aGUNCj4gZGF0YWJh
c2UuIFBsZWFzZSBtYWtlIHN1cmUgeW91IHNwZWNpZmllZCBjb3JyZWN0IGlu Zm9ybWF0aW9uLiI7
DQo+IH1lbHNlew0KPiBlY2hvICJTdWNjZXNzZnVsbHkgY3JlYXRlZCB0YWJs ZS4gRG8gc29tZXRo
aW5nIGhlcmUiOw0KPiB9DQo+IA0KPiBteXNxbGlfY2xvc2UoJGN4bik7DQo+ ID8+DQo+IA0KPiAN
Cj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCj4g
DQo+IFZpc2l0IGdhbGFjdGljd2ViZGVzaWducy5jb20gZm9yIHR1dG9yaWFs cyBhbmQgbW9yZSEN
Cj4gDQo=
------=_NextPart_000_005B_01C7C530.D1BC9E50--
Re: PHP & MySQL Issue!
am 13.07.2007 04:47:54 von niel
Hi
Give us a clue? What's the error(s) you get returned?
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: PHP & MySQL Issue!
am 13.07.2007 04:50:23 von Austin C
------=_Part_28799_7762183.1184295023011
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hello, I dont get any errors. Just a blank page. But, I go to the database,
and it did what I told it to with the header table, but not with the
circulation table.
On 7/12/07, Niel wrote:
>
> Hi
>
> Give us a clue? What's the error(s) you get returned?
> --
> Niel Archer
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Thanks, the webmaster of Galacticneo
------=_Part_28799_7762183.1184295023011--
Re: PHP & MySQL Issue!
am 13.07.2007 04:51:49 von dmagick
Austin C wrote:
> Hello everyone, im trying to use PHP to create 2 tables in a database and
> populate them with tables, however, it just wont work.
Where does it stop working? Looks fine from what you've shown us but you
need to track down the problem a bit further.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: PHP & MySQL Issue!
am 13.07.2007 16:25:11 von Dwight Altman
--Apple-Mail-4--128918742
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed
On Jul 12, 2007, at 9:50 PM, Austin C wrote:
> Hello, I dont get any errors. Just a blank page. But, I go to the
> database,
> and it did what I told it to with the header table, but not with the
> circulation table.
Check your error log or add this as the first line in your script.
ini_set('display_errors', '1');
Maybe you are testing this on a production server with errors not
displayed.
Remove the line before you deploy the code.
Hopefully you will see a meaningful message now.
Regards,
Dwight
--Apple-Mail-4--128918742--
Re: PHP & MySQL Issue!
am 13.07.2007 17:51:59 von Dwight Altman
--Apple-Mail-5--123710338
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed
On Jul 12, 2007, at 9:50 PM, Austin C wrote:
> Hello, I dont get any errors. Just a blank page. But, I go to the
> database,
> and it did what I told it to with the header table, but not with the
> circulation table.
After you built the SQL for the circulation table, you did not
execute it [with a $query = mysqli_query($cxn,$sql);]. Instead, you
selected the db again. Your code did what you told it to do. Hence,
no error messages.
Regards,
Dwight
--Apple-Mail-5--123710338--