I am trying to play around with this tool. I am able to add rows to the database but 'edit' and 'delete' don't seem to work. I am a newbie to PHP. What could be the reason?
My code:
<sqltemplate database = "mydb" tables="Project" limit="5" type="edit">
<TABLE border='1'>
<TR>
<TH>ID</TH>
<TH>Project Name </TH>
<TH>Description</TH>
<TH>Environment</TH>
<TH>Project Type</TH>
That looks like it should work... are you getting an error message, or is it just not editing your data?
Do you know what your configuration is? (e.g. what version of PHP and MySQL you're running?) You should be able to figure it out by making a page that has the following content:
<?php phpinfo(); ?>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Welcome to Open Discussion
Hi,
I am trying to play around with this tool. I am able to add rows to the database but 'edit' and 'delete' don't seem to work. I am a newbie to PHP. What could be the reason?
My code:
<sqltemplate database = "mydb" tables="Project" limit="5" type="edit">
<TABLE border='1'>
<TR>
<TH>ID</TH>
<TH>Project Name </TH>
<TH>Description</TH>
<TH>Environment</TH>
<TH>Project Type</TH>
</TR>
<sqlrow>
<TR>
<TD><sqlfield name="Project_Id" type="text" /></TD>
<TD><sqlfield name="Project_Name" type="textfield" /></TD>
<TD><sqlfield name="Proj_Desc" type="textfield" /></TD>
<TD><sqlfield name="Environment" type="textfield" /></TD>
<TD><sqlfield name="Project_Type" type="textfield" /></TD>
<TD><sqlaction type="edit" /><sqlaction type="delete" /></TD>
</TR>
</sqlrow>
<TR>
<TD colspan="6" align="center"><sqlaction type="previous" /><sqlaction type="next" /></TD>
</TR></TABLE>
</sqltemplate>
That looks like it should work... are you getting an error message, or is it just not editing your data?
Do you know what your configuration is? (e.g. what version of PHP and MySQL you're running?) You should be able to figure it out by making a page that has the following content:
<?php phpinfo(); ?>