|
You have two processes, don't complicate things by joining them together. Attack each problem separately. First, figure out a way to get your CSV into the database - should be fairly simple. Do you need users to upload the CSV through the web site or can you use BCP on the SQL Server to load it yourself? Answer questions like that and then you can start to tackle the CSV import problem.
Once you have the data in the database, or at least you are sure of the database schema, you can start to design your charting tool. I suggest using an existing charting library like one of these...
Google Charts[^]
Flotr2 Charts[^]
|
|
|
|
|
Basically I need this DHTML popup to show once per 12 hours for the visiting user. I can't seem to figure it out...
This is in the code for the pop:
<script type="text/javascript">
var dragapproved=false
var minrestore=0
var initialwidth,initialheight
var ie5=document.all&&document.getElementById
var ns6=document.getElementById&&!document.all
function iecompattest(){
return (!window.opera && document.compatMode && document.compatMode!="BackCompat")? document.documentElement : document.body
}
function drag_drop(e){
if (ie5&&dragapproved&&event.button==1){
document.getElementById("dwindow").style.left=tempx+event.clientX-offsetx+"px"
document.getElementById("dwindow").style.top=tempy+event.clientY-offsety+"px"
}
else if (ns6&&dragapproved){
document.getElementById("dwindow").style.left=tempx+e.clientX-offsetx+"px"
document.getElementById("dwindow").style.top=tempy+e.clientY-offsety+"px"
}
}
function initializedrag(e){
offsetx=ie5? event.clientX : e.clientX
offsety=ie5? event.clientY : e.clientY
document.getElementById("dwindowcontent").style.display="none"
tempx=parseInt(document.getElementById("dwindow").style.left)
tempy=parseInt(document.getElementById("dwindow").style.top)
dragapproved=true
document.getElementById("dwindow").onmousemove=drag_drop
}
function loadwindow(url,width,height){
if (!ie5&&!ns6)
window.open(url,"","width=width,height=height,scrollbars=1")
else{
document.getElementById("dwindow").style.display=''
document.getElementById("dwindow").style.width=initialwidth=width+"px"
document.getElementById("dwindow").style.height=initialheight=height+"px"
document.getElementById("dwindow").style.left="30px"
document.getElementById("dwindow").style.top=ns6? window.pageYOffset*1+30+"px" : iecompattest().scrollTop*1+30+"px"
document.getElementById("cframe").src=url
}
}
function maximize(){
if (minrestore==0){
minrestore=1
document.getElementById("maxname").setAttribute("src","<TMPL_VAR site_url>/images/restore.gif")
document.getElementById("dwindow").style.width=ns6? window.innerWidth-20+"px" : iecompattest().clientWidth+"px"
document.getElementById("dwindow").style.height=ns6? window.innerHeight-20+"px" : iecompattest().clientHeight+"px"
}
else{
minrestore=0
document.getElementById("maxname").setAttribute("src","<TMPL_VAR site_url>/images/max.gif")
document.getElementById("dwindow").style.width=initialwidth
document.getElementById("dwindow").style.height=initialheight
}
document.getElementById("dwindow").style.left=ns6? window.pageXOffset+"px" : iecompattest().scrollLeft+"px"
document.getElementById("dwindow").style.top=ns6? window.pageYOffset+"px" : iecompattest().scrollTop+"px"
}
function closeit(){
document.getElementById("dwindow").style.display="none"
}
function stopdrag(){
dragapproved=false;
document.getElementById("dwindow").onmousemove=null;
document.getElementById("dwindowcontent").style.display=""
}
</script>
and this in the main body of the page
<SCRIPT LANGUAGE="JavaScript">
if (window != top) top.location.href = location.href;
</SCRIPT>
<div id="dwindow" style="position:absolute;background-color:#EBEBEB;cursor:hand;left:0px;top:0px;display:none" onMousedown="initializedrag(event)" onMouseup="stopdrag()" onSelectStart="return false">
<div align="right" style="background-color:navy"><font size="1" color="white">Loading ad....Please wait a few seconds or close the ad....</font><img src="<TMPL_VAR site_url>/images/close.gif" id="page_effect" onClick="closeit()"></div>
<div id="dwindowcontent" style="height:100%">
<iframe id="cframe" src="" width="100%" height="100%"></iframe>
</div>
</div>
<script>
if (ns6) window.onload=new Function('loadwindow("http://AdURLhere.com",900,900)')
else
loadwindow("http://AdURLhere.com",900,900)
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#page_effect').fadeIn(80000);
});
</script>
Any help would be appreciated. thanks
|
|
|
|
|
I have created a elevator functionality [there are 2 floors and corresponding to each one , there is a checkbox. Depending upon which checkbox is checked, the elevator should move to that floor.
Only thing which i am not able to implement here is:
Make the checkbox check automatically and slowly fadeout to unchecked state when the orange elevator has reached that checkbox.
Here is the link to the markup and script: http://jsfiddle.net/hurricaneankit/qR4uJ/
|
|
|
|
|
Hmmm... i would use a loop (for / next) to change the Color from yellow to the background in small steps and the opposite way to fade it in on the other box...
Martin
|
|
|
|
|
For your animate() function, you can pass in a function to execute when the animation is completed. You can't "fade" your checkbox, but you can un-check it.
$(function(){
$(document).ready(function () {
$("#check1").click(function () {
$("#check1").toggleClass('checked');
$("#check2").removeClass('checked');
$("#groundDiv").animate({
"top": "0px"
}, 1000, function () {
});
});
});
|
|
|
|
|
How can sites developed in php or any other language be integrated into a downloadable mobile web application
|
|
|
|
|
PHP is an ServerSide Language and can not run in the Browser like an HTML File that you open... To Use PHP you allways require an Webserver that supports PHP (i am not aware if there is an Xammp installation for Mobile devices...)
Also, Mobile devices are using different Brwosers and different OS's.
As long as you do not specify what kind of Mobile Devices you want to use, HTML5 or/and Java would be the most flexible way.
Martin
|
|
|
|
|
Hello! I have a problem for you guys
*Sorry for my English I'm French 
I would like to build a stage composed with three superimposed plans.
The background is a set which can contain arbitrary graphic elements, by an image or a series of images.
The median plan is a time line on which are aligned objects (symbolized by icons)
The foreground allows the display in close-up of an object, accompanied with a note.
The navigation in the page is made with the scroll (horizontally or vertically).
Both plans of the background move by respecting an effect of parallax, the closest plan moving faster than the plan in the back which give a deep impression..
When a icon situated on the time line passes in the center of the window, it is " intercepted " and placed from the point of view of focus.
When an object is on this plan, it is associated with a note wich give its definition.
Here's an image:
http://www.freeimagehosting.net/3u11g[^]
The problem has 4 parts:
1) Find a method to make a scroling of the graphic elements (Parallax?)
2) Determine if an icon of the line of time line is in the middle of the window
3) Resize the icon and show the associated text.
4) Move the HTML element associated with the icon of the branch
DOM " Time line " towards the branch "Focus ".
|
|
|
|
|
Hey all,
I've just found this question on http://codeine.io
Anybody interested in helping out for $50?
Cheers,
Simon
|
|
|
|
|
HI All,
I want to hide printer dialog box in javascript.
Any help will be appreciated.
|
|
|
|
|
That is a web page/browser issue and nothing to do with Javascript.
"It's true that hard work never killed anyone. But I figure, why take the chance." - Ronald Reagan
That's what machines are for.
Got a problem?
Sleep on it.
|
|
|
|
|
What kind of doc you want to print without displaying the print dialog? Do you want to print the current page? a PDF file?
|
|
|
|
|
i am learning php from [http://www.lynda.com/PHP-tutorials/php-with-mysql-essential-training/435-2.html]. When i am at the "Building a Content Management System" part, i am having some trouble.
This is the mysql database:
mysql
this is the php code:
php code
i can't understand line 19,30
|
|
|
|
|
|
In addition to Richard's comment, I'll point out that mysql functions have been deprecated.
You should instead be using the PDO or mysqli extensions. (They sanitize user-input and help protect your databse)
For more info, see here: http://bobby-tables.com/[^]
Make it work. Then do it better - Andrei Straut
|
|
|
|
|
I just constructed a reporting system using PHP and MYSql, it worked fine on my WAMP but since making it live sometimes it throws an error and won't allow anyone to insert data.
I think it's because multiple people are trying to enter data at the same time or it could be just on my end.
Is there a way to handle the traffic? I was looking at "deadlock" and found this:
$retry=0;
$notdone=TRUE;
while( $notdone && $retry<3 ) {
try {
$transaction->begin();
$do_all_the_transaction_stuff();
$transaction->commit();
$notdone=FALSE;
} catch( Exception $e ) {
// here we could differentiate basic SQL errors and deadlock/serializable errors
$transaction->rollback();
$retry++;
}
}
if( 3 == $retry ) {
throw new Exception('Try later, sorry, too much guys other there, or it's not your day.');
}
I tried to implement it but it ended up sending 11,000 copies of the information entered into the form.
How do I use this? I have four fields i'm trying to enter data to.
Thanks for any and all help,
to be honest I don't even know if I'm on the proper track or not...
Rob
|
|
|
|
|
I'm loading some html as a text string, and displaying it in an ASP.Net page.
The html has a link in it, and the link isn't clickable. It is decorated link a link, but the cursor doesn't change to the finger.
What would be causing that?
EDIT ==================
Well, I tried pasting the code into the aspx file, and that didn't help UNTIL I moved it to be before a series of canvas tags. But any link that follows the canvas tags don't work.
EDIT ==================
The problem was that the canvases were too big, thus somehow masking the link tag.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
modified 11-Apr-13 9:45am.
|
|
|
|
|
Please post the offending code.
"It's true that hard work never killed anyone. But I figure, why take the chance." - Ronald Reagan
That's what machines are for.
Got a problem?
Sleep on it.
|
|
|
|
|
See my updated post (2nd edit).
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
|
|
|
|
|
Have you tried enclosing the link(s) within <p></p> tags?
I've seen similar quirks with large tables.
"It's true that hard work never killed anyone. But I figure, why take the chance." - Ronald Reagan
That's what machines are for.
Got a problem?
Sleep on it.
|
|
|
|
|
I have a form with many dropdowns and text boxes and a file upload.
I want to display the file path as soon as it uploaded without refreshing the entire form.
I am able to upload the file but the file path doesnot get displayed in the label.
however after refreshing the entire page i get the file path displayed in the label
Please help me
|
|
|
|
|
Please do not cross post.
Frazzle the name say's it all
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
John F. Woods
|
|
|
|
|
Hi,
Everyone please tell me in which way i can list all content of a doc file or pdf file in a PHP page.
|
|
|
|
|
Hi
I am trying to develop a webpage that will display images that are stored on a server and then allow the user to right click on the image and save it to their local disk.
This should be simple but the images on the server are not stored using the standard .jpg extension even though they are jpeg images, they have .d01 extensions and I have no control of this. In IE7 when you right click on one of these images the "Save Picture As" option does not work, it just says "System can't find specified file", oddly the Email Picture option does work.
Is this something which is peculiar to IE7 and can I get around it in some way. Unfortunately due to restrictions on company PCs I can't update IE or install other browsers.
Regards
Andrew
|
|
|
|
|
When I put my video file which is wmv about 4M on my web server directly and using html embed wmp to display the video, it seems very slow or even not displaying the video.
Any suggestion so my large video file could be played on website without waiting for a very lone time WITHOUT using streaming server?
Is that convert video to flv and played by flash player a good solution?
Many thanks.
modified 4-Apr-13 23:49pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
