Inserting into DB problems
Brought to you by:
nileshd
Menu
▾
▴
Hi All
PhpCodeGenie works great for me except inserting data into the MySQL DB,
I log into the insert page, insert the data, click OK and it looks as if all has gone correctly, but when I go into WebMin and browse the table entries there are just blank entries. PHPCodeGenie creates new rows but leaves them blank.
Any help would be greatly appreciated as im not a DB guru :)
Cheers
Justin
Below is my Insert code
<?
include("head.php");
include("datacon.php");
?>
<?
$query="insert into todo_asset (Asset_ID,Assert_Name) VALUES ('$Asset_IDField','$Assert_NameField')";
$result = MYSQL_QUERY($query);
?>
<H2>New Todo_asset Created !!</H2>
<table>
<tr height=30>
<td align=right><b>Asset_ID :</b></td>
<td><font color=blue><b><? echo $Asset_IDField; ?></font></b></td>
</tr>
<tr height=30>
<td align=right><b>Assert_Name :</b></td>
<td><font color=blue><b><? echo $Assert_NameField; ?></font></b></td>
</tr>
</table><br><br>
Click <a href="index.php">here</a> to go back to Main Menu
<?
include("foot.php");
?>
I'm having exactly the same problems. When I use the form entry which I've named index.php, it accepts the info and sends me to itsertxxx.php.
The resulting page states that the record has been inserted, but the listing below this comment is empty. The database did add a record, but the fields were blank.
I know enough about PHP and HTML to see that the generated code is okay. I did change all <?'s to <?php however.
The program looks good, but the letdown is in having to use 2 include files. I don't have problems with a db include like the datacon example you get on the home page, but why have a settings.php? What does it do? Why is it needed? Can't any necessary code (if any) be included in datacon.php?
I've tried everything I know to get the form to work, but it just refuses. I'm running localhost on the latest WAMP upload on XP. If I can actually get this thing to work properly I'll gladly produce a user manual all all to share. As it is, it looks like the author has shelved the project for over a year and any requests for help in this forum are generally ignored.
Being over a year since the last update, I'm wondering if the code from version 1.4 actually works without without having to be changed by the user. Having to do any changes defeats the purpose of the software.
Well that's my carrot if you're out there Mr Programmer. The program looks like it will do the job perfectly, so help me to get it to work and I'll put together a user guide for you
Im having the same issue too. At the beginning it worked great but I reached 82 records, the program simply DOESNOT WANT to insert any data into DB although I didnot touched neither database nor the code itself. I generated again the code and tried but without success. Can any PHP developper give us a help ? We would appreciate a lot. Please :)
Are you sure you have register_globals set to true?
Seems like phpCodeGenie somehow depends on it...
@shellyco: sure that that setting hasn't changed between the 82nd and 83rd record?
Btw: even though I am a Java-programmer I will try to make some changes to the php-code to change this. If some other php-crack wants to join me... contact me.
It somehow seems that since last year there is no more development going on... Somebody contacted the developer already?