
ratcateme
Members-
Posts
1,216 -
Joined
-
Last visited
Never
Everything posted by ratcateme
-
is the server linux and did you set it up so have full root access then you could configure sendmail to send to your isp's SMTP do you have a email account with your ISP then you can proberly access your ISP SMTP server by SMTP.[isp].com replace [isp] with your isp address AOL would be smtp.aol.com Scott.
-
[SOLVED] Prevent url changes to cheat the code?
ratcateme replied to djfox's topic in PHP Coding Help
why don't you use SESSION to store all the information like scores so people cant cheat at all Scott. -
have you setup a port 80 forwarded in your router Scott.
-
i don't no much about domain names but get someone on a different network to try to connect i had this problem with a no-ip address Scott.
-
if you have full server access look for you mail logs in /var/log/ and try removing the @ from in front of you mail() command Scott.
-
[SOLVED] Importing Data From Microsoft Excel into MySQL database
ratcateme replied to PC Nerd's topic in PHP Coding Help
you could try this i don't no how often you want top do this but this has a 30 day free trial you could use in the short term Scott. -
try modifying your move_uploaded_file to include the full file name move_uploaded_file($_FILES["file"]["tmp_name"], dirname(__FILE__)."reelfiles/" . $_FILES["file"]["name"]); i had a similar problem and that fixed it Scott.
-
do you have access to the sendmail logs to see if the email is getting to sendmail. and have you check your span box i a had a problem where my emails were going to my pan box Scott.
-
i worked it out after looking over the js file from phpMyAdmin i was trying to set object.class .class dosn't exist i needed to set .className
-
if you put them one level up there is no way AJAX could access them Scott.
-
you could create a function and use [ur=http://nz2.php.net/manual/en/function.func-get-arg.phpl]func-get-arg[/url] to get the args but i write all my query's inline with out functions Scott.
-
year sorry i see what you are doing now you need to change <?php echo "$date";?> to <?=$_GET["date"]?> and repeat for the rest i think i no what happed when you switched servers you had register_globals on with your old server and when you switched it was turned off this stuffed all your scripts you could try turning it on and see what happens Scott.
-
so you get a blank page not even a "No data." message Scott.
-
you need to change your echo's to return's function checkSession($sessionName) { if(isset($_SESSION["$sessionName"])) { return $_SESSION["$sessionName"]; } else { return "none"; } } Scott.
-
i have this table when i click on a line the tick box is checked and a new style is applied to change the background this is my form Code: <table> <tr class="normal" onmousedown="if(document.getElementById('check_15569').checked==true){ document.getElementById('check_15569').checked=false; alert(this.class); this.class=''; alert(this.class); }else{ document.getElementById('check_15569').checked=true; alert(this.class); this.class='normal_checked'; alert(this.class); }document.getElementById('check_15569').checked"> <td><input type="checkbox" name="rows_selected[]" value="15569" id="check_15569" /></td> <td>10.1.1.2</td> <td>2008/02/03 07:37 PM</td> <td>GET</td> <td>/update_logs.php</td> <td>200</td> <td>27</td> <td>Firefox 2.0</td> </tr> </table> The tick box get ticked but i get undefined on the first alert and the class i am trying to change to in the second alert i am trying to create a display somewhat like phpMyAdmin if this helps Scott.
-
[SOLVED] Importing Data From Microsoft Excel into MySQL database
ratcateme replied to PC Nerd's topic in PHP Coding Help
sorry i think that only writes not reads xls files Scott. -
[SOLVED] Importing Data From Microsoft Excel into MySQL database
ratcateme replied to PC Nerd's topic in PHP Coding Help
i don't know about converting a xls sheet into query's but it might be possible. But i think i found a way to use straight xls files using this pear package http://www.codeplex.com/PHPExcel/Wiki/View.aspx?title=Home Scott. -
it would be impossible to do a still accept AJAX there is no way to tell between AJAX commands and general browser viewing you can check POST vars sent by AJAX but anyone can create those POST vars to view your page Scott.
-
[SOLVED] Importing Data From Microsoft Excel into MySQL database
ratcateme replied to PC Nerd's topic in PHP Coding Help
someone else had a similar question i gave them this code <pre> <?php $con=mysql_connect(); mysql_select_db('test'); //number of lines to skip $skip=1; $current_line=1; $sheet='test.txt'; $file=fopen($sheet,'r'); while(!feof($file)){ $line=fgets($file); //add this if($current_line>$skip){ $line=explode("\t",$line); $query='INSERT INTO `table` VALUES ('; foreach($line as $key => &$value){ if($key==0){ $query.="'".$value."'"; }else{ $query.=", '".$value."'"; } } $query.=');'; echo $query."\n"; mysql_query($query,$con); //add this } $current_line++; } fclose($file); ?> </pre> this is designed for xls files saved as txt but if you want change the "\t" to "," on line 16 to use csv and set the number skip according to how many lines are taken up by titles and headers Scott. -
what values are being set in require('../inc/config.php'); is there a $username value Scott.
-
can we see some code to help us find your problem Scott.
-
thanks sasa it works with that Scott.
-
the fact you can get them from a function without having to call it specially i think.
-
it doesn't match my expectations but i don't no why because if i look at all the results with no where clause there are many results that should be included in th first query and a hole lot that are smaller than 1000 in the second query i am wondering if > is supported in a where clause dose anyone no anything about that Scott.
-
i removed ASC but nothing pma gives the wrong results to Scott.