I agree with the above post, disabling such functionality is a nuisance. It can't be done with php but may be possible using javascript.

However, considering people use very different web browsers...

Should be pretty simple, each excel entry should have a unique ID, therefore duplicate insertion into a database CANNOT happen.

Is this true for you?

(*) Please don't post your entire code as...

http://www.tizag.com/phpT/fileupload.php

Javascript might be an option, have you checked out dhtml?

If you want a domain name so it resolves to your ip address then you will need to buy a domain name. You also need to configure your router to accept connections etc.

You need to give a better example than that.

OK if I use a linux server, which is feasible, although my mom is gonna screw at me for wiping off windows LOL, does this avoid the problems regarding SMTP setting etc?

Thanx in advance.

No I'm not getting anywhere with this.

I think my mail SMTP is mail.btinternet.com

It returned successful when I did a telnet on port 25.

Start > run > (type in cmd)
telent...

Crap, is this a lot simpler to set up using linux then?

I think to do that, it is going to be more effort than it's worth, but then what do I know. LOL

Maybe
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html#function_match

I wouldn't use reg ex.

I would just look for a substr within the string.

Thank you for your reply, but what do I put for the smtp settings. Would it have something to do with my Internet service provider, would it be localhost? I'm confused :(

btw (I don't have an...

I'm afraid that didn't work, anyone else?

How do I send an email...

I have WAMP (windows xp apache, mysql and php).

But what do I do now. Explain...

Yes install wamp it saves a lot of trouble. Unless you enjoy wasting time.

Maybe see
http://www.depts.ttu.edu/helpcentral/directions/ODBCSetup.php

So explain the following then:


http://docs.hp.com/en/36216-90103/ch03s02.html

Or are you talking about non-correlated sub queries. Please explain.

>I think sub-queries are much faster than joins and also easier to understand.

What do you mean by faster...

Using ODBC is by far the easiest way to do this, since you can connect to any database, on any computer on your network. It happens to be really simple to configure in Administrative Tools as well. ...

Try using http://poi.apache.org/
http://sourceforge.net/projects/phpexcelreader/

The best way would be to convert it to a csv file and then just parse through it.

What makes you think he is using a database?

>My guess is that it has to do with the version of php my hosting company has

So have you tried that, with your version of php and has it worked?

If you know how to generate one random number, surely you can generate two? I presume you have the intelligence to go to google and type in random numbers php?

Have you thought about using regular expressions.

Take out the if condition and put some echos there to see what output you're getting.

I'm curious about the $baseSection = (substr($row[0],-2,-1)=="_") -1 here in line 5?

I mean have you tried my code?

You might also need to use the function:-

htmlspecialchars
http://ific.uv.es/informatica/manuales/php/function.htmlspecialchars.html

along with n12br()

If...

I think it just reads out the file, line by line. To be honest I don't really use php, I just copied that snippet from the net.

Does that mean we can mark this thread as being solved? :)

what happend?

Obviously that doesn't account for tabs or newlines... Any luck, I can't actually test that thing as I'm not on my linux box which has the php on it?

Can you test the following as a separate php script and tell me what you see?


<?php
$filename = "file.txt";
$fp = fopen($filename, "r") or die ("nope");
while (!feof($fp))
{
$line =...

In that case something else is counting the number of letters in your code when you are reading the thing back in.

Can you test my code on its own as a separate php file please?

When you have ran that script open the text file and tell me what you see?

I dunno does the below make any difference?


$string = 'This is a $gfd \' goo.d string £-$,';


if (preg_match("/[^A-Za-z0-9 .,-£$']/", $string)) {
print 'string is NOT OK!';
} else { ...

I dunno, maybe you just need to write to a file:


<?php
$fp = fopen("file.txt","w") or die ("couldn't open!");
fwrite($fp, "blah\n");
fclose($fp);
?>

You have a mysql function which does exactly this you know?
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

encrypt it?

maybe...

http://www.webmasterworld.com/forum88/13187.htm

second post from bottom

You can also use mysql functions as well.

Huh, if you have repetitive code use functions!


>it ll take around 2000 rows... which means 50kb

Where did you pick that random number from honey? (50kb) Nonsense!


148 posts and no sign...

>0000-00-00

This is meaningless. At least say something like: yyyy-mm-dd