Jump to content

NLCJ

Members
 View Profile  See their activity

  • Posts

    129

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by NLCJ

    Change src of iframe

    in Javascript Help

    Posted

    The Chrome inspector - or whatever it's called - helped me a lot. It seems I forgot a ")", what caused all scripts to fail within those tags (I guess that makes sense?). Now the only thing that isn't working is changing the href. But I think I will figure something out, I will keep you guys updated. ;)

    Change src of iframe

    in Javascript Help

    Posted

    JavaScript is now acting really weird, I've got no clue what happened but no script works anymore... Even the scripts that I didn't modify! I've set it like:

    function verifyfile() {
			var ext = $('#file').val().split('.').pop().toLowerCase();
			if($.inArray(ext, ['avi','mpg','mpeg','wmv','mov','vob','flv']) != -1) {
			    document.getElementById('errorextension').style.display="none";
			    document.getElementById('uploadbutton').style.display="block";
			} else {
			    document.getElementById('errorextension').style.display="block";
			    document.getElementById('uploadbutton').style.display="none";
			}
		}
		function uploadfile() {
			document.getElementById('uploadform').style.display="none";
			document.getElementById('processing').style.display="block";
			setTimeout(uploadstarted(),10000);
		}
		function uploadstarted() {
			document.getElementById('uploadprogress'.style.display="block;
			document.getElementById('processing').style.display="none";
		}

    verifyfile() is called when the file is changed in the form, it worked fine until now. Now nothing works, even though I didn't touch that part... Does anyone know what happened or how I can solve this? I'm pretty new in JavaScript, maybe it's a silly mistake or so...

    Change src of iframe

    in Javascript Help

    Posted

    I can't get it to work. I've set it like this:

    iFrame code:

    <iframe name="uploadprogress" id="uploadprogress" style="display: none; border: none; width: 100%; height: 300px;" src="about:blank"><p>Your browser doesn't support iFrames...</p></iframe>

    JavaScript code:

    function uploadfile() {
document.getElementById('uploadform').style.display="none";
document.getElementById('uploadprogress').style.display="block";
window.uploadprogress.location.href="uploadprogress.php?id=test";
}

    Like before, the style.display works, but the window.uploadprogress doesn't... :(

    Verifying the file extension that will be uploaded

    in Javascript Help

    Posted

    Hello,

    I got a HTML form where users can upload a file. Since these files can be pretty big (about 4-5GB) I thought I would let JavaScript verify it so they don't waste time for an error (ofcourse I still got a backend verification). What I did is: I added an onchange="verifyfile()" to the file part of the form. And I made (with the help of Google ;)) this JavaScript:

    function verifyfile() {
var ext = $('#file').val().split('.').pop().toLowerCase();
if($.inArray(ext, ['avi','mpg','mpeg','wmv','mov','vob','flv']) == 1) {
    document.getElementById('errorextension').style.display="none";
    document.getElementById('uploadbutton').style.display="block";
}else {
    document.getElementById('errorextension').style.display="block";
    document.getElementById('uploadbutton').style.display="none";
}
}

    It works fine if I, e.g. start with an .avi file and after that I get a .rar file. First I don't get the error message, and after that I get the error message.

    However, it doesn't work the other way around. If I first do a wrong extension the button disappears and the error comes up, but if I change it to the right extension nothing happens.

     

    I'm kinda lost and new in JavaScript so...

     

    Regards,

    Change src of iframe

    in Javascript Help

    Posted

    Hello,

    I've been creating an upload script, and it's going great so far after big problems. But now the final touch... I want to change the src of an iframe when the button is pressed. I got this:

    function uploadfile() {
document.getElementById('uploadform').style.display="none";
document.getElementById('uploadprogress').style.display="block";
document.getElementById('uploadprogress').src="uploadprogress.php?id=test";
}

    The .style.display part works fine. The iframe is being displayed, however the URL is not changed...

     

    Am I doing something wrong?! What?! :P

    Upload progress bar

    in PHP Coding Help

    Posted

    I found the problem, I think. When I couldn't solve it I was searching for the original docs of this extension. After a few broken links I found the examples at:

    http://svn.php.net/viewvc/pecl/uploadprogress/tags/RELEASE_1_0_1/examples/

     

    Copying and viewing those resulted in a page with the information about the current settings. A few of those are:

    ('upload_max_filesize' is 50M per file)

    ('post_max_size' is 8M per submit)

    I was aware of the max filesize of 50M, so I uploaded files around 40M. Due to the post_max_size being 8M it wouldn't return any information. So I tried a 6M file with the example script, and it resulted in the wanted results! :)

    Upload progress bar

    in PHP Coding Help

    Posted

    The form gets an unique id, just for testing I set it manually:

    <input id="UPLOAD_IDENTIFIER" name="UPLOAD_IDENTIFIER" type="hidden" value="12345" />

    This field will tell the extension uploadprogress that the identifier for this upload is 12345. Then you should be able to get it by using filename.php?id=12345: 

    <?php print uploadprogress_get_info($_GET['id']); ?>

    However, it seems that no data is being made using this extension. I got no clue... :) Once I figured it out I will post it here.

     

    Upload progress bar

    in PHP Coding Help

    Posted

    Hello,

    I've been trying to create a progress bar for the past 3 days, but I can't get it to work. I've got my own dedicated server with cPanel on it, using cPanel I installed the PECL extension. However, it doesn't respond to anything. The script I'm using is:

    HTML code:

    <form id="uploadform" enctype="multipart/form-data" method="post">
					<input id="UPLOAD_IDENTIFIER" name="UPLOAD_IDENTIFIER" type="hidden" value="12345" />
					<input id="ulfile" name="ulfile" type="file" />
					<input type="submit" value="Upload" />
				</form>

    To request the information I made another page with:

    <?php print uploadprogress_get_info($_GET['id']); ?>

     

    Nothing is returned however, no error, nothing... I'm totally lost!

     

    Regards,

    Hide / show on mouseover

    in Javascript Help

    Posted

    Nevermind, I've rewritten it:

    <script type="text/javascript">
function show(box){
	document.getElementById(box).style.visibility="visible";
}
function hide(box){
	document.getElementById(box).style.visibility="hidden";
}
</script>

    <img onmouseover="hide('amenu'); show('dmenu');" src="navigate.png" width="180" height="30" id="amenu" style="visibility: visible;" />
<div id="dmenu" onmouseout="hide('dmenu'); show('amenu');">

    Works fine. ;)

    Hide / show on mouseover

    in Javascript Help

    Posted

    Hello,

    I'm trying to hide and show something if it's shown (on mouseover) and vice versa when the mouse goes over the other div. However, it doesn't work (anymore). I've got no idea what happened. I changed something and it didn't work anymore (I tried CTRL + Z, didn't work).

    function menutop(hide, show){
var hide = document.getElementById(hide);
if(hide.style.visibility == 'visible') { hide.style.visibility = 'hidden'; } 
if(hide.style.visibility == 'hidden') { hide.style.visibility = 'visible'; }

var show = document.getElementById(show);
if(show.style.visibility == 'visible') { show.style.visibility = 'hidden'; }
if(show.style.visibility == 'hidden') { show.style.visibility = 'visible'; } 
}

    HTML code:

    <img onmouseover="menutop('dmenu', 'amenu')" src="button.png" width="30" height="30" id="amenu" style="visibility: visible;" />
<div id="dmenu" onmouseout="menutop('amenu', 'dmenu')" style="visibility: hidden;">

     

    Thank you,

    MySQL queue

    in Applications

    Posted

    Okay, I've been away for a while but started yesterday again. I'm working on inserting with multiple values, but what if it already exists? Then it got to update it... So I was looking for 'ON DUPLICATE UPDATE', but have no clue... How would I do it if I have multiple values?

    INSERT INTO foo (name,variable) VALUES ('apple','".$variable."'), ('banana','".$variable."'), ('pear','".$variable."') ON DUPLICATE KEY UPDATE variable='".$variable."'

    Would this work / will it update the right row?

    MySQL queue

    in Applications

    Posted

    PFMaBiSmAd gave you great advice.  The one thing you need to keep in mind is that if you are going to be doing a query using a WHERE column that specifies a column, like in your example 'name' then you need to have an index on that column for performance reasons, or the query will need to tablescan through looking at every row for matches of name.

     

    Also when you do inserts, you can batch them by repeating the values as he alluded to.  This is a lot more efficient for the database when compared to individual inserts. 

     

    
INSERT INTO foo (name) VALUES ('apple'), ('banana'), ('pear') etc

     

    Currently I'm converting the database, and I already figured that INSERT INTO 'trick' out, and successfully modified that part (I have to admit it looks way better now).

     

    But I don't understand the first part of your post, can you give an example for that?

     

    By the way, I won't be here until about monday. Thanks for all your help though!

    How do I secure this HTML Form and Email Script?

    in PHP Coding Help

    Posted

    Please notice that if you use the method specified above, the user will have to refill all the fields. In order to prevent that you can use:

    <input type="text" name="first_name" size="50" value="<?php echo $first_name; ?>"/>

     

    Not like this though, as you would get undefined index error's, you need to check to see if the var is there (isset()) but yes, this logic is the right approach...

     

    Rw

     

    What do you mean? I always get the wanted result. If an user submitted the form, and that field was empty it will echo 'nothing' -> empty.

    MySQL queue

    in Applications

    Posted

    You can probably make your existing code 2x faster by eliminating all the unnecessary and redundant mysql_real_escape_string() function calls.

     

    Using mysql_real_escape_string() on values that your script produces, such as data('Y-m-d') or $average is not necessary because those values can never have characters in them that need escaping.

     

    You are also using the same value several different times, such as $values[0] and $_GET['type']. You should escape them once and then just use the escaped value every place.

    Thank you, a while ago I read that this way was as fast as without mysql_real_escape_string. I will do that. Also I wasn't aware that $_GET['type']  slows it down. I will make it better, and see how it goes. Thanks!

     

    And I created this database structure because I thought it was easier for the server. Apparently a table with more than 50.000 rows is faster?

    Slow initial page load with PHP/mySQL

    in Applications

    Posted

    PHPFreaks is right. Another way to fix this is to set your nameservers, the first one to that server and then the other one to the router / modem. In this way your computer will look at the server first and then go onto the internet. At this moment it's searching for that IP address at the internet, and then going local. I think you've got multiple routers or so?

    MySQL queue

    in Applications

    Posted

    Lets say that every line got a specific ID. If that ID doesn't exist, it creates a table for that ID. Then it will insert the rest of the information into that table.

    Why did I do it this way?

    I thought this would be less heavy for the server when requesting, because when all ID's are in the same table it would have more than 50.000 rows.

    MySQL queue

    in Applications

    Posted

    Thank you for your reply. This is the part of the code:

    for($number = 0; $number <= $lines - 1; $number++) {
                  if($error = 1) {
                     break;
                  }else {
                     if($setinactive != 1) {
                        mysql_query("UPDATE `".$d_userinformation['username']."-".mysql_real_escape_string($_GET['type'])."s` SET status='inactive'");
                        $setinactive = 1;
                     }
                     $values = explode(",", $postedinfo[$number]);
                     $since = date("Y-m-d", strtotime($values[1]));
                     $lastclick = date("Y-m-d", strtotime($values[2]));
                     $differencedate = (strtotime($since) - strtotime(date("Y-m-d")))/(24*60*60);
                     if($differencedate == 0) {
                        $differencedate = 1;
                     }
                     $average = $values[3] / $differencedate * -1;
                     $d_checkexistence = mysql_query("SELECT * FROM `".mysql_real_escape_string($values[0])."` LIMIT 0,1");
                     if($d_checkexistence == false) {
                        mysql_query("INSERT INTO `".$d_userinformation['username']."-".mysql_real_escape_string($_GET['type'])."s` (name,since,importedtime,lastimport) VALUES ('".mysql_real_escape_string($values[0])."','".mysql_real_escape_string(date("Y-m-d"))."','".mysql_real_escape_string(date("H:i:s"))."','".mysql_real_escape_string(date("Y-m-d"))."')");
                        mysql_query("
                           CREATE TABLE  `".mysql_real_escape_string($values[0])."` (
                           `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
                           `since` DATE NOT NULL ,
                           `lastimport` DATE NOT NULL ,
                           `imported` DATE NOT NULL ,
                           `username` VARCHAR( 255 ) NOT NULL
                           ) ENGINE = MYISAM ;
                           ");
                        mysql_query("INSERT INTO `".mysql_real_escape_string($values[0])."` (since,lastimport,imported,username,status) VALUES ('".mysql_real_escape_string($since)."','".mysql_real_escape_string($lastimport)."','".mysql_real_escape_string(date("Y-m-d"))."','".mysql_real_escape_string($d_userinformation['username'])."','active')");
                     }else {
                        mysql_query("UPDATE `".$d_userinformation['username']."-".mysql_real_escape_string($_GET['type'])."s` SET since='".mysql_real_escape_string($since)."',lastclick='".mysql_real_escape_string($lastclick)."',clicks='".mysql_real_escape_string($values[3])."',average='".mysql_real_escape_string($average)."',lastimport='".mysql_real_escape_string(date("Y-m-d"))."',status='active' WHERE name='".mysql_real_escape_string($values[0])."'");
                        mysql_query("UPDATE `".mysql_real_escape_string($values[0])."` SET since='".mysql_real_escape_string($since)."', lastclick='".mysql_real_escape_string($lastclick)."', clicks='".mysql_real_escape_string($values[3])."', average='".mysql_real_escape_string($average)."', username='".mysql_real_escape_string($d_userinformation['username'])."' WHERE imported='".date("Y-m-d")."'");
                     }
                  }
               }

    They all are different actions / tables, so it doesn't seem to get faster in my opinion.

     

    MOD EDIT: 

     . . .

    tags added.

    MySQL queue

    in Applications

    Posted

    Hello,

    I've created a little script, that takes infromation from a CSV file and then imports it into the database. Sadly, this can be up to 5 query's per line. Some files are big (then I mean more than 4000 lines) and require full attention of the server, which makes all other sites slow. So I was wondering if it's possible to limit it to for example 5 or 10 query's per second? Like putting all the queries into a queue and then spread it over the time.

     

    A CSV file with 200 lines takes about 20 seconds now, what I'm afraid of is that the user thinks that the site is stuck so he refreshes it, what resends it and then gives inserts it again. Ofcourse I've got a protection for that, but it definetly can make the server freeze.

     

    Regards,

    P.S.:

    I'm sorry if it's placed in the wrong forum. I was not sure where to place it!

     

    EDIT:

    Okay, I just saw that I placed it in PHP Applications. It was meant to be in Coding Help...

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.