firedrop84

Hi Everyone, I wasn't sure which categoriy I should post this topic as I am not even sure of where the issue is. At , the programmer has went on holiday and I end up assigned to fix some issue with the site as I have some knolwedge of PHP. After I have looked at the site, I can see the programmer has used PHP, IIS as a service. However, the issue is that they have upgraded the server from IIS5, Windows 2000 to II6 and WIndows 2003. Once they have upgraded it, the site doesn't show all the data. Initially, I thought there is a problem with the DB as most of the data from the db it doesnt show. However, I checked the db and it is working perfectly fine. I then noticed that everything doesn't work in the site which is related to the db that is after I login but before I login I can see the data from the db. After some investigation, I guess I reached to the conclusion that the issue is with the session and that is why I dont see the data. The code is the same and it was working perfectly fine with IIS5, WIndows 2000 but once i upgraded to IIS6 WIndows 2003 I am getting this issue. Any idea, suggestion? I approciate your coproation with this?

Thanks everyone for your reply. I just would like to make it clearer of what I am trying to have. I am trying to change the date format in excel from dd/mm/yyyy to timestamp in order I can import at later stage in the database. I tried =(((E2-(6*3600))/86400)+25569) but it didn't work. I had in field B2 the date and I used the formula in C2. It changed it from 1/1/2010 to 1/1/1970!!.

Hi, I have an excel sheet with many data there. I am trying to import all these data to the righ tables in the database which I could manage to do it successfully. However, the issue I am facing is with the date coloumns. in the database, I am using a timestamp and the field is integer in the db (yes, I know I could use date as the field type but now it's quite late to change as it might affect my php code). my question is how can I change a normal date format in excel from something like dd/mm/yyyy to timestamp in excel. Any ideas? Best Regards, Ahmed

Thanks Daniel. Let me try it and I will let you know.

Thanks Daniel, your support is greatly approciated and I really need it. I am studying my masters but I am from Information System background not Computer Science which they gave us almost no math in uni. Matrix is a new concept for me. However, I asked a guy who graduated in math and he explained it for me. He doesn't have any IT knowledge. Based on what he said, I developed the sheet attached. The stuff I wrote in red in the attachment it's really just the index that it will be in the array. I thought if I have two arrays and each as two colomuns and two rows. Then, I thought maybe then I need to divide them into four arrays which they are C11, C12, C21, C22. You will see with the black pen is where I am getting the elements I need from each array. Then, I finish it by having a final array by adding the result into a final array. hmmm, nested for loop. Let me try to think how can I do it. to make my question clearler . This is a link of a thesis. Please look at page 294 - 299 which explains what I am trying to do. http://www.debii.curtin.edu.au/~ponny/doc/PhD_THESIS.pdf [attachment deleted by admin]

I am basically trying to know how can I multiple two matrix in PHP.

Hi Everyone, I have a problem in regards the coding that I am trying to develop. I am trying to implement some concept which uses matrix but I didn't find any matrix function in php which does that. I done some calculation which is working fine and now I have two arrays which I need to multiplie the first and the second array and get a new array. I have to do it twice for a two dimminssional array and a single diminssioanl array. Can any help advice how this can be done. p.s. I already found this one site which has a class for it but it's quite complex. Any other site you know about it or any ideas you can give that might help http://www.phpclasses.org/browse/package/2859.html. Your advice is greatly approciated.

Hi, I am currently trying to develop a prototype which I need to divide the page into two seperate page. When the user interacts with the left sidfe of the page nothing happens to the right side and the same for the right side. Any idea what will be the best and easier way to do that. I thought of frames but then I said let me check if there is something else around. the second question I got is if anyone have seen around a php script where users can vote on a topic but each user are assigned to a group where each grou phas different weight of voting. For example, if Experts in IT voted they get double marks than normal guyz and so on. this is all need to be in php.

Hi, I am in process of developing a website. However, currently I got a new requirment which I have to create a mail merge feature to the website. The mail merge should have email and mail (in the future maybe sms as well). In other words, users they search for customers and they get a result (i already got this search feature). Then, they can export it by either choosing a letter which is already saved in the database and merge it with those customers that has been searched for or write a new letter. It's a time consuming task to develop so i was thinking if i can buy something like this feature (a ready code or something). Any idea where can I get a code to intergrate it to my website.

Hi All, I am trying to find out a way to be able to read, edit, write, etc and OWL file in PHP. I know Java does support Ontology but I am not sure if PHP does as I couldn't find much about it on net. Anyone has any idea about this topic as I need some guidlines how I will be able to do it. Thanks in advance.

Thank you for your reply. I have attched the script that I am using for the date picker. Can you help on re-arrange it as i dont have much knowledge in JS. Regards, firedrop [attachment deleted by admin]

Hi All, I got a java script that is Date Picker but the format is year - month - day (YYYY - MM - DD). I need a date picker which is with different format (DD - MM - YYYY). something without time. does anyone knows where can I get a script on net that is already written for this. Regards, Firedrop

Dear All, I am developing a website which one of the client requirments is to have an HTML Editor. In other words, there will be a control panel that he can add Text, Hyperlinks, Images, Tables, changing font colours and size, etc in the control panel. Once he is able to do that it should be save in the database and then viewed in other page anytime with the format that he has entered in the control panel. For example, Let's say I have a page in the site called About Us. In this page he wants to be able to go the control panel and do all the formating and then once he visit About Us page he sees the page with all the format he entered. I am thinking of this can be possible. Any Idea of how can I do this. Regards, firedrop

Hi All, I have a problem with one of the functions that I am using in my website. The function basically forth staff to shift on/off. I test it into three cmputers that they show me different errors. The first computer it works fine unless if there isn't any row in the database. it displays an error when I try to shift on. The error is: Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\CBDHealthSpa\test.php:130) in C:\Program Files\xampp\htdocs\CBDHealthSpa\test.php on line 147 The second computer it display a debug error any time i try to shift on/off. The debug it attached into the message. The third computer it works find for the first time when I shift on/off. The second time or even more it dsipaly the same debug error. I have attached a zip file that contains the php code and a screen shot of the debug error. Any one can help me with this. Regards, firedrop [attachment deleted by admin]

Hi everyone, I am using PHP, MySQL and Apache. I have coding some pages after I finished them and test them through localhost I didnt had any errors with them. I decided after that to uploaded into my server (on internet) and I had lots of warrning massages and lots or most of the pages that is related with the database it shows me a warrining massage. below is an example of a warring massage that displays Warning: mysql_query(): Unable to save result set in C:\Inetpub\vhosts\getonlinesystem.com\httpdocs\new\MyAccount.php on line 23 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\getonlinesystem.com\httpdocs\new\MyAccount.php on line 25 the same page with the same code it works on localhost. When I test it on localhost or when I host it on the server I use the same database. can anyone give me an idea why its doing this is it because of different version or which reason it could be.

you can do this in several ways. Mainly by using header function. check out the link below. It shows different ways you can do it. you can specify the second that you want to refersh the page. [a href=\"http://www.desilva.biz/php/phprefresh.html\" target=\"_blank\"]http://www.desilva.biz/php/phprefresh.html[/a] Regards, FiReDrOp

Hi Everyone, I got a system that has some PHP files. The PHP files they are depending on a text file. When I run them on the localhost it works. I got a problem when I want to run them on the server. It dpesn't open, read or write to/from textfile. Regards, Firedrop

I have been using all the way a software called XAMPPLite to develop a website. I have almost finished it so I have sent all the SQL script and the files to an IT Manager of some business so they upload it into their server. The IT Manager he replied and he said that he uploaded everything but there are SQL errors. one of the errors is Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0 this is eror displays when I try to login. does anyone have idea about this error massage.

Here is the code for the page [code] <?php         // connect tot he database     require ('connection.php'); $GetFollowUp = mysql_query("SELECT p.ProspectID, p.RegDate, p.Title, p.Surname, p.GivenName, p.FlatRoomNumber, p.StreetNumber,   p.StreetName, p.Suburb, p.State, p.PostCode, p.Primary, p.Other, p.Email,  p.EnquiryType, p.Source FROM prospect p, followup f WHERE (f.ProspectID = p.ProspectID)");     $HowMany = mysql_num_rows($GetFollowUp);          $y = 0;     for ($v = 0; $v < $HowMany; $v++)     {         $y++;         if (isset($_POST["$Name[$y]"]))            {            print "Hello";         }              }              if ($GetFollowUp && $HowMany != 0)     {         $i = 0;                              while($data = mysql_fetch_array($GetFollowUp))         {             $ProspectID[$i] = $data["ProspectID"];             $RegDate[$i] = $data["RegDate"];             $Title[$i] = $data["Title"];             $ProspectSearch[$i] = $data["Surname"];             $ProspectGivenName[$i] = $data["GivenName"];             $FlatRoomNumber[$i] = $data["FlatRoomNumber"];             $StreetNumber[$i] = $data["StreetNumber"];             $StreetName[$i] = $data["StreetName"];             $Suburb[$i] = $data["Suburb"];             $State[$i] = $data["State"];             $PostCode[$i] = $data["PostCode"];             $Primary[$i] = $data["Primary"];             $Other[$i] = $data["Other"];             $Email[$i] = $data["Email"];             $EnquiryType[$i] = $data["EnquiryType"];             $Source[$i] = $data["Source"];                               $i++;           }     }         for ($w = 0; $w < $HowMany; $w++)         {             $Name[$w] = "$ProspectSearch[$w]" . " $ProspectGivenName[$w]";         }                                mysql_close();              // Assign the Data that has been retrieved into an array         if ($GetFollowUp && $HowMany != 0)         {             // Dispalay the headings             print "<form name=\"form1\" method=\"post\" action=\"\">";               print "<table width=\"500\" border=\"0\" align=\"center\">";             print "<tr bgcolor=\"#0033FF\">";               print "<td><div align=\"center\"><span class=\"style3\">No. </span></div></td>";               print "<td><div align=\"center\"><span class=\"style3\">Follow Ups </span></div></td>";             print "<td bgcolor=\"#0033FF\"> Quick Add </td>";             print "<td> Prospect Details </td>";             print "<td> Completed </td>";                      print "</tr>";                      $n = 1;                      // Display the data             for ($x = 0; $x < $HowMany; $x++)             {                 $BtnCompleted[$n] = "BtnCompleted$n";                 print "<tr bgcolor=\"#EEEEEE\">";                 print "<td>$n</td>";                   print "<td>$ProspectSearch[$x] $ProspectGivenName[$x] </td>";                              print "<td> No</td>";                              print "<td> <input type=\"submit\" name=\"$Name[$x]\" value=\"Details\"></td>";                 print "<td> <input type=\"submit\" name=\"$BtnCompleted[$n]\" value=\"Completed\"></td>";                 print "</tr>";                 $n++;             }         }         elseif ($HowMany == 0)         {             // Dispalay the headings             print "<form name=\"form1\" method=\"post\" action=\"\">";               print "<table width=\"200\" border=\"0\" align=\"center\">";             print "<tr bgcolor=\"#0033FF\">";               print "<td width=\"40\"><div align=\"center\"><span class=\"style3\">No. </span></div></td>";               print "<td width=\"144\"><div align=\"center\"><span class=\"style3\">Follow Ups </span></div></td>";             print "</tr>";                      print "<tr bgcolor=\"#EEEEEE\">";             print "<td colspan=2> <center> No Follow Ups </center></td>";             print "</tr>";             print "</table> </form>";         } ?> [/code]

Hi .. I have a problem with the following code. I got a page that displays some results based on the data that is in the databse. the output it displays in a table. in that table there are 5 coloums. the the first row it just display the number. the second display the name. The forth coloumn it displays a button and the name of the button is the same name of the customer on that row. the last coloumn it just basically displays another button. my porblem is with the forth coloumn. that is with the buttons. I want when the employee clicks on that button it should go to another page. I tired to use isset with for loop nested with if but it didn't work. can anybody help me on solving the mistake that I have in my code. I changed the header to just print "Hello"; and that just to test if it is going to display but it didn't. // The databse result has already been retrieved // the problem is with this code $y = 0; for ($v = 0; $v < $HowMany; $v++) { $y++; if (isset($_POST["$Name[$y]"])) { print "Hello"; } } // Then I have displayed the table

I got a problem with session. I have used session in the login page. I would like to use them inot different pages as well . When i try to use them in the other pages it changes the value of the login page. I mean the session value in the login page. For example, in the login screen I got a variable called surname and then when I try to use it into different page let's for example I want to display Welcome and then the surname. It display at the beginning the value that is in the login screen. and then it changes when I try to do some other stuff into different pages. I haven't posted the code into here because I dont know where the problem is from and from which page.

Hello .. I have been trying to use the code that you have adviced me to you use I mean ober code. It shows me some errors. the error is Application name: Microsoft Excel Loaded version: 11.0 Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft Office Excel Description: 'test.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.' in C:\Documents and Settings\12966233\Desktop\xampplite\htdocs\test1.php:16 Stack trace: #0 C:\Documents and Settings\12966233\Desktop\xampplite\htdocs\test1.php(16): variant->Open('test.xls') #1 {main} thrown in C:\Documents and Settings\12966233\Desktop\xampplite\htdocs\test1.php on line 16 and line 16 is $Workbook = $excel_app->Workbooks->Open("$filename") or Die("Did not open $filename $Workbook"); so can anyone help me with this error as I really dont know why it is not working. Regards, firedrop

Hi ... I am using XAMPP for a project I am working on it now on my computer. I have checked the php.ini and my secript and I am quite sure that they are correct. The thing that i think I am missing is to run the e-mail server. How can I do that if I have my computer and I use XAMPP. I found a folder in the XAMPP package called XAMPP that is a program been written I think with Delphi. The read me file leads to this link www.glob.com.au/sendmail I am trying even to use the wizard but I when i tried to choose the directory it shows some error. The error is Failed to find Bugzilla in the selected directory .. anybody can help ?!?! I dont know how to solve been spending on it quite long but couldn't figure it out.

I am using to php. I got in my page a radio button. The group contains of Yes and No. The default is No. I want when the browser change it to yes it changes the value in the database to Yes just like updating in the database. also if returns it back to it updates again in the database. Regards, firedrop

I got a menuList that php generates it by reteriveing from the database all teh data from one attribute. I want when the user chooses one of the List Menu to display in the text file some other data that also comes from the datbase. Example, The menu list contains Employee Types ... Admin .. Manager .. Sales Rep. when the user chooses Manager it displays in another textfield 3. If it is Admin it display in the text filed 4, etc. does anyone knows how to do that. Regards, firedrop