JasonO

Thanks for the reply, it's working out fine so far. Is there any rules on special characters or what not when using JSON decode function? I've noticed that some of the arrays are placed inside arrays unnecessarily (eg: [[[test],1]] extra brackets around outside array) - is there anyway i can delete an array if its not containing anything but a single array within it?

Hi, A piece of software I'm using an array is made that looks like the following: [["Select","Vehicle",0.142933,[0.15,0.4,0.05,0.01]]] How would I be best parsing it so: Square brackets currently showing an array becomes an array within PHP Text strings surrounded by "quotations" lose the quotation mark when stored in the PHP array Numbers remain as values in the PHP array The arrays can become quite large, so which would be the best way to go about it? Regards, Jason

Well, I got something put together. This is what I have. Can you guys suggest a better way or point out any pottential errors? I've thrown thousands of lines of the log through it and no issues so far. $logData = $_POST['logData']; $entries = explode("\n", $logData); ?> <table style="border: 1px solid #000000; border-collapse: collapse; width: 240px;"> <tr> <td style="border: 1px solid #000000; border-collapse: collapse; padding: 4px;"><b>Player Name</b></td> <td style="border: 1px solid #000000; border-collapse: collapse; padding: 4px;"><b>Player ID</b></td> </tr> <?php foreach ($entries as $i => $entry) { if(!strpos($entry, "connected (id=")) { // The line doesnt refer to 'connected' thus not relevent here unset($entries[$i]); } else { echo "<tr >"; // A basic strip down of stuff we always never need $newEntry = substr_replace($entry, "", 0, 16); $entries[$i] = $newEntry; // Take out the Player Name $playerName = substr($newEntry, 0, strpos($newEntry, "connected (id=")); // Take out the Player ID $playerID = strstr ($newEntry, "connected (id="); $playerID = substr_replace($playerID, "", 0, 14); $playerID = ereg_replace("[^0-9]", "", $playerID ); // Print into our table row echo "<td style=\"border: 1px solid #000000; border-collapse: collapse; padding: 4px;\">".$playerName."</td><td style=\"border: 1px solid #000000; border-collapse: collapse; padding: 4px;\">".$playerID."</td>"; echo "</tr>"; } } echo "</table>"; Turns results into a table like: Name ID Jason 1234567 Tom 9512312

It would be a setting in your MySQL server. Usually remote accesing the database is disabled by most web hosts for security reasons, although (don't quote me though) there might be some kind of whitelist for certain IP's to be allowed to connect.

Your system is almost identicle to mine. I would personally say it depends how complex the system you are working on is. For example, something with multiple themes could deserve its own folder, but a single CSS file is fine on its own in my opinion. To be honest I'm not sure if there is a standard. It's kind of like theres no standard to how a mechanic lays out his tools or an administrator lays out their desk. That's how I'd look at it. I'll probably say that and someone will point me in the direction of a strict file system now

Its because you have an index.html file there as well. Rename or delete it and it will make your PHP file load instead of the HTML one. http://www.i-love-stickers.com/index.html Is the same as http://www.i-love-stickers.com/ But is different to http://www.i-love-stickers.com/index.php

It seems you are using the curly brackets for more than whats required. You only need them when you have things like if, else, while, for etc etc. <?php if (!isset($_POST['submit'])) { ?> <table cellspacing="2" align="center" valign="center" bgcolor="f5f5dc"> <form action="?p=login" method="post" > <align="center">Members <br /><br /><tbody ><td> Enter Your Member ID </td> <td><input type="text" name="id" size="15" /> </td> </tr> <tr> <td class="name"> Enter Password </td> <td> <input type="password" name="pass" size="15" /> </td> </tr> <tr> <td> <input type="submit" value="Submit" name="submit" /><br /><br /> </td> </tr> </form> </table> <?php } ?> <?php echo" Please enter valid ID <A href='javascript:history.back()'>click here</A> to go back"; $query="select * from members where ID='$id'"; $data = $sql->Query($query); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $dpass=$sql->data[1]; } $cpass=crypt($pass, substr($pass,0,2)); if ($dpass==$cpass) { // Code is cut off? ?> Couldn't understand the last bit, it looks like its cut off or something.

Between the variables and the string in your echo statement you do need the dots. Example: echo "<li><h3>".$title."</h3><span><p>".$infobox."</span></li>"; They are used to join your various pieces to form your line of code.

Hi there, I have a log file which has lines like the following: 22:18:09 USER Tom.D connecting. 22:18:16 geo987 INCLUDES FILES - CA;@ACE;@add1 22:18:20 USER Jason connected (id=30537990). The lines I'm interested with is the one containing the users ID.. There are many other lines in the log as well, however its only the connected one I want to worry about. What would be the best way to approach this so I can get the Username and ID from these lines into seperate variables. The username can contain symbols and the id could be a length of anything from 4 digits to 15+; which is what I'm finding an issue. Thank you for your suggestions, Jason

I thought the timestamp is the number of seconds since 1st Janurary 1970? I would like to store the date with the time being 00:00, otherwise I'll have the problem when the cron job runs the script just after midnight (runs every day at 00:05), it won't see the time as being 'today'. If the number of seconds at midnight is 1000 for example, at 1 minute past midnight it would be 1060. In 10 minutes it would be 1600. If I wanted to see if anything of that day was due, it wouldn't work correctly as 1000 is less than 1060 for example. Damn, I'm finding this really hard to explain. Heh. Is there a better way of doing it then? I just wanted to go by the current concept of that if the checking script run by the cron has a current time thats after the one in the database, it would mean that the database row needs updating. If the time in the database is at, say 2PM, the cron job wont pick that up until the next cron. Sorry I'm not very good at explaining it :|

Hi everyone, How would I go about getting the timestamp of the current day, rounded to the most recent time of 00:00? For example, If I used 10/02/2010 at 14:43:32 it would give me a timestamp for that by default (as that is the current time of posting this). However, how would I get it to get the timestamp for 10/02/2010 00:00 ? Is there a way to easily round the earliest 00:00 time? I don't want it to round ahead as I can't time travel. Thanks.

Perfect. Learnt a lot about mod_rewrite now. Thanks very much for your help

Yeah, I figured that out after posting. Couldn't edit it though and didn't want to double post. I've managed to not get an error to show, although now I just get a 404 error error with a 2nd variable. I actually want a 3rd one possible too if I can. RewriteRule ^([a-zA-Z0-9-]+)/?$/^([a-zA-Z0-9]+)/?$ /index.php?page=$1&act=$2 RewriteRule ^([A-Za-z0-9-]+)/?$ index.php?page=$1 [L] I keep playing around with the symbols to try and get it to work but no joy

It simply puts $txt into a function (although I'm not sure that function is) and the returned value of that is then placed back in to the $txt variable. The function tagWrap has 3 parameters. Tag, Text and Func. Whatever function is passed into the tagWrap will depend on what it returns (will be nothing if $func refers to a non existant function). If you look at line 15 you will see of the functions 'underline'. It's more or less an expanded function of that, but allowing it to be more dynamic (ie can use any function that exists within it, rather than just underline).

Hey everyone, Currently I have the following mod_rewrite: RewriteEngine On RewriteRule ^([A-Za-z0-9-]+)/?$ index.php?page=$1 [L] At the moment this converts any URL in the following format: http://domain.com/pagename to http://domain.com/index.php?page=pagename Works great! However, I need to get a 2nd parameter into my URL, but no matter how much I read on it and how much I tweak it (constant server errors etc) I can't get the following: http://domain.com/firstpage/secondpart to end up as http://domain.com/index.php?page=firstpage&act=secondpart Anyone able to point me down the right path? It's driving me mad! :-\ This is the closest I think I've got, but still server error. RewriteEngine On //RewriteRule ^([A-Za-z0-9-]+)/?$ index.php?page=$1 [L] RewriteRule ^([a-zA-Z0-9-]+)/([a-zA-Z0-9]+)$ /index.php?page=$1&act=$2 RewriteRule ^([a-zA-Z0-9-]+)$ /index.php?page=$1 Regards, Jason

That easy huh? Damn. I was searching for something for more advanced, missing it because it's that simple. Next time I'll make sure I

Hi, If I wanted to find the date (DD MM YY for example) of the next Tuesday (or any day I choose really) thats going to occur, how would I go about this? I've had a look at a few of the date functions but no idea where to start on piecing it together selecting the first date of a particular day I choose (Monday or Tuesday or Wednesday etc). Eg. The next Tueday is on... DD-MM-YY The next Satuday is on... DD-MM-YY Thanks! Jason

Hi guys, I have a table, where each row is loaded from the database. At the end of the row is the word Edit. When I click Edit I would like all the data in that row to change to text boxes, and the word Edit changing to Done and Cancel I am currently using jQuery but am very new to it. How would I go about this? What do I need from where etc? I have no idea if something out there like a plugin for jQuery exists or not. I tried searching and got something called jEditable but have no idea how to modify it for a table-based system. Thanks for your help Jason

Amazing, works a treat. I've managed to sort all the data into tables and it's very neat and easy process thanks to your function. Fantastic, thank you!

<?php $string1 = "Blah"; $pattern = "/[A-z]/"; if (preg_match($pattern, $string1, $matches)) { echo "Match was found <br />"; echo $matches[0]; } else { echo "No Match"; } ?> I have this, but to check for "quotation marks" around the text, and if theres not add them is way beyond my skill

<?php $number_columns = 2; // manually set the number of columns $break_point = ceil($totalRows_rsWorkshopRegistrants / $number_columns); // divide total rows by 2 to find break points $counter = 0; // start a counter ?> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> <td valign="top"> <?php do { $counter++; // count the output ?> <?php echo $row_rsWorkshopRegistrants['FirstName'] ?> <?php echo $row_rsWorkshopRegistrants['LastName'] ?><br /> <?php if (($counter % $break_point) == 0) { // if current row is equal to break_point echo "</td><td valign='top'>"; // close cell and start a new column } ?> <!-------LINE 106 ----------> <?php } while (($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants, MYSQL_ASSOC))) ?> </td> </tr> </table> <table border="0"> <?php do { ?> <tr> <td> </td> <td > <?php echo $row_rsWorkshopRegistrants['FirstName'] ?> <?php echo $row_rsWorkshopRegistrants['LastName'] ?> <br /> </td> </tr> <tr> </tr> <!-------LINE 106 ----------> <?php } while ($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants, MYSQL_ASSOC)); ?> </table> Does this make any difference? In a line similar with mine, I have MYSQL_ASSOC after the the variable of the query result.

I'm looking up and seeing things based around the preg_match function, but I am unable to find a correct pattern to detect if it has quotation marks around it or not.

New topic instead of reply I think? :|

Update. It works to a point, I found that since it's not actually JSON code there are times where the function will fail. [bank,"TNL_bank_acc_123456"] This fails because bank is meant to be a string, but is not represented as one with speech marks around it. Using this validator I found this to be the cause of the issue: http://www.jsonlint.com/

Amazing, theres a PHP function already that can do the trick! Json_decode works brilliantly ["test1","1234",500,500,"",4] With that being put through json_decode.. Array ( [0] => test1 [1] => 1234 [2] => 500 [3] => 500 [4] => [5] => 4 ) Brilliant! Even works with multiple arrays in an array! Thanks for your help, never thought it would be that easy