echo this: "SELECT * FROM tsttbills where date >= '$sDate' and date <= '$eDate'"
This is a valid query, I just think the format of the dates may be incorrect or maybe you don't have any dates that fall between these dates. One of the two.
move this line: error_reporting(E_ALL ^ E_NOTICE); on gcrFunction.php to just before the include statement on line 2 of testGCR.php and comment out these lines.
first, get the "Web Developer" add on for firefox, then go to http://www.i-spy360.com/spins/spin6/Spin360.html and use the "Web Developer" option called "View Javascript" under the information tab. Then you can see how they do it.
I usually use tineMCE, which looks like it does exactly the same thing. If you want to do that I can help you with that, but chances are they have enough documentation and examples that you won't need my help.
$checkdisabled is pluged into the checkbox so when you pull the query, if the column "disabled" is 1 then checked="checked" is added to the checkbox making it checked else that will be left out making it unchecked. I know a lot of people just put the word checked in the checkbox tag but checked="checked" is the correct xhtml syntax.
moved the delete block to the top so the file is deleted before you fill the form with the current existing files. Included current url redirect to refresh after the post(just a personal preference) because I think is reflects a better experience for the user to not have to worry about reposting every time the user wants to refresh the page after a post. Changed the checkbox name to an array, and the script loops through all the checked items of the array.
<?php
$path = "test";
if(isset($_POST['file']) && is_array($_POST['file']))
{
foreach($_POST['file'] as $file)
{
unlink($path . "/" . $file) or die("Failed to delete file");
}
header("location: " . $_SERVER['REQUEST_URI']); //redirect after deleting files so the user can refresh without that resending post info message
}
?>
<form name="form1" method="post">
<?php
$path = "test";
$dir_handle = @opendir($path) or die("Unable to open folder");
while (false !== ($file = readdir($dir_handle))) {
if($file == "index.php")
continue;
if($file == ".")
continue;
if($file == "..")
continue;
echo "<input type='CHECKBOX' name='file[]' value='$file'>";
echo "<img src='$file' alt='$file'><br />";
}
closedir($dir_handle);
?>
<input type="submit" name="Delete" value="Delete">
</form>
the problem is that when you post a variable name that includes a ".", the "." is automatically replaced with an "_". You can see that by putting print_r($_POST); at the top of your file.
few slight changes, was getting headers already sent error: fixed that's probably what was messing with the excel parsing. that's about the only thing though, nice script.
liked the way you used $head[] = mysql_field_name($sql, $i); gonna have to try that.
Just a tip to help you bypass the frustration: Usually when I am exporting to csv, excel, pdf or anything, I always have two different modes, production mode and development mode.
In production mode, of course I am outputting the desired output like normal. In development mode I am just outputting straight to the browser or textarea or whatever allows me to analyze my output the easiest. I usually have this set in a variable at the top.
This allows you to analyze the actual behavior of your code without involving any more variables then necessary at the time.
You were looping through with a counter and using the loopnumber as your id, this will only work if you are absolutely positive that your ids are sequential, looks like you are using register globals I think. I've …
In javascript we can swap only jpg images? Then what about the gif images. Please help me. By answering my first post so the second post will be solved automatically.
It's just plain text either way, image type has nothing to do with it. I mean it's not like you are reconstructing the images, your just swapping text.
I guess you could also do that in the database too. Have like an faq_activity table that updates every time a user views an faq and then you could just pull the 4 most recent for that user. You'd have to keep it cleaned up else it will get fairly large, but it could be as simple as a faq_activitypk, faqpk and userpk.
$query = "select distinct faqpk, userpk from faq_activity where userpk = " . $userpk . " order by faq_activitypk desc limit 4";
I am using some little cookies, where I store a user information for example: nickname and password.
And try sessions also,if you want to store more user data like nick name etc...
Exactly, I'm not too excited about my password being stored in a cookie, maybe an md5 of my password, but I even get nervous about that. I think its just bad practice.
You can't stop someone from creating multiple accounts unless you block entire IPs, which you don't want to do because most IPs are shared. The only thing you can do is keep people from creating accounts with information that has already been used, for ex. email address, user name, nick name etc...
Fixed a couple of bugs 1. wouldn't display last page number, now it does 2. pages started at zero, now they start at one 3. on last page next and last were still displayed, fixed.
edited the code above to fix bug in the last page variable because round may go up or down. So I included a little block at line 28 to test the total pages * amount per page and see if it was greater than the total, and if so subtract 1 from total pages. And you probably want to do some type of validation of the inputs before querying the database.
Ya you are definitely going to want to generate these on the fly, that is unless you want to create thousands of pdfs manually.
Run this on your server to see if pdflib is installed.
if(!extension_loaded("pdf"))
{
echo "pdflib is not installed";
}
You will want this installed since it is the most popular and the most documented pdf extension. I have heard that there are other extensions you can use instead, but this is by far the most widely used.
