Search the Community

Hi guys Could any one tell me the best way to encript data from php and store it in mysql This would be a realy big help as the system is going to store sensative data Thanks JToland

I use the following code to allow parents to email into the school while keeping the the email address hidden. Its a simple post form going to another php page with the following code. $to = $_REQUEST['sendto'] ; $from = $_REQUEST['Email'] ; $name = $_REQUEST['Name'] ; $address = getenv('REMOTE_ADDR'); $headers = "From: $from"; $subject = "Email From School Website"; $today = date("d/m/Y"); $minutesseconds = date("l dS \of F Y h:i:s A"); $fields = array(); $fields{"Name"} = "Name"; $fields{"Regarding"} = "Regarding"; $fields{"Email"} = "Email"; $fields{"Message"} = "Message"; $fields{"address"} = "Recieved from Ip address $address this email was posted on $minutesseconds (add 6 hours for GMT time) "; $fields{"Sender"} = "This email was sent to $to"; $body = "We have received the following email via the school website:\n\n"; foreach($fields as $a => $b){ $body .= sprintf("%20s: %s\n",$b,$_REQUEST[$a]); } $headers2 = "From: [email protected]"; $subject2 = "Thank you for contacting "; $autoreply = "Thank you for contacting us. A member of staff will get back to you as soon as possible. If you have any more questions, please visit our website http://www.wykeregisjun.co.uk"; if($from == '') {print "You have not entered an email, please go back and try again";} else { if($name == '') {print "You have not entered a name, please go back and try again";} else { $send = mail($to, $subject, $body, $headers); $to ="[email protected]"; $send = mail($to, $subject, $body, $headers); $send2 = mail($from, $subject2, $autoreply, $headers2); if($send) {header( "Location: http://www.wykeregisjun.co.uk/sendingemail.php" );} else {print "We encountered an error sending your mail, please notify [email protected]"; } } } ?> Unfortunately we are getting a ton of spam being sent through. What I really need is a way of checking if the message contains "http://" and if it does then to not send the email and redirect to another page. Any PHP gurus out there that can help please?

I have one of these that works ";} elseif ($lib_num<'22') {echo "web/img/tick.png"; } elseif ($lib_num=='28') { echo "web/img/full.png"; } else {echo "web/img/warning.png"; Tried changing it for another part of my page but can't see where i'm going wrong if ($lib_opened['active']=='1') { echo "web/img/full.png"} else { echo $lib_num ." of 28 PCs used" .; } I just get the error i've been coding all day and my eyes hurt now!

me again with another php question cos i know you all love me we have webhelpdesk set up using a mysql db. i've just had a look through and it stores the helpdesk tickets under the job_ticket table. in that table it has the job name/job description/date submitted etc which I hope i could pull out quite easily with some php. the problem is, it doesn't list the username in there, it lists the user ID, which is then a part of the client table along with their username. now i know to get all the jobs from job_ticket i could just grab all the rows, loop them in php and set variables for ticket_name/ticket_desc etc. i know i could also do something like: SELECT * FROM `helpdesk`.`client` WHERE `CLIENT_ID` = xxxx but then how do i pair the two, so as it goes through the loop getting the job details, it then checks the user id, finds the username from it and carries on? would it be something like $query="SELECT * FROM job_ticket"; $result=mysql_query($query); $num=mysql_numrows($result); $i = 0; while ($i < $num) { $jobname=mysql_result($result,$i,"job_name"); $jobdesc=mysql_result($result,$i,"job_desc"); $userid = mysql_result($result,$i,"user_id"); $query2 = "SELECT * FROM `helpdesk`.`client` WHERE `CLIENT_ID` = $userid"; $result2 = mysql_query($query2); $user_name = mysql_result($result2,$i,"user_name"); echo "$user_name $jobname $jobdesc "; $i++; } bearing in mind i've never done php in depth before this week so this is all sort of cobbled together from examples and what i assume would be correct. would what i've posted above work? my one thought is that in the $user_name variable i've set it to use $i but $i was used for the initial query, not the username query, so would it still work or would i have to change something?

Our booking system was outdated (VB6 I think it was done in) so, after finding no nice clean alternatives that did what we wanted on the web I got to designing my own. The majority of development is now finished and we've rolled it out in school to trial. Uploaded a few screenshots for those that are interested. Once we are happy it works as needed I will get about releasing this to the public. [ATTACH=CONFIG]8554[/ATTACH][ATTACH=CONFIG]8553[/ATTACH][ATTACH=CONFIG]8552[/ATTACH][ATTACH=CONFIG]8555[/ATTACH][ATTACH=CONFIG]8556[/ATTACH]

I'm in the process of designing a new web site. This will most likely be written in PHP/HTML/Java, using MySQL as a data store. Once the website is completed, I want to transfer the site to a droid app (among other things) and it seems the only (from what I can see) way to do this is by making a REST-ful site. I don't want to create the site until I know exactly what I need. I understand the REST concept (I think), but I can't see any tutorials on how to create a REST-ful site in PHP etc etc Can anybody help me out, or perhaps suggest another way to allow droid apps to retrieve data from a MySQL database?

I have an apache 2.2.11 server with php 5.2.9 and mysql 5.1.34 running on 64bit windows server 2k3. i have enabled the ldap extensions within php, but am not sure on how to use the ldap stuff, what i would like it to do is to pick up the users system login details and display their username. once i have got that i would like to deny access to pages depending on which ad group they are in, which i don't know how to do either.

Has anyone used jupdate to upgrade their Joomla 1.5 to 1.6? I can't even seem to get it to start. Installed ok and added the moo_tools and enabled that. When I open the Jupgrade I get the 'Start Upgrade' image, but cannot click it. Its just an image rather than a link?

Similar to what the post here I am trying to have a form submit to a PHP page which then forwards the request using PHP mailer. This is what i have for the the form checkbox selection in the form RAMP1P2P3P4RPMP5P6 Then in the PHP script I Have $periods = $_REQUEST['periods']; But all that gets submitted through the email is Array? What have i done wrong?

Hi Forum Our company has upgraded to MS Exchange server 2010 Sp1 but now my Imap PHP scripe does not connect or does not receive a reply from Exch 2010. We use to have Exch 2007 Sp2 and it worked fine. $username="domain/user"; $password="password"; $mbox=imap_open("{172.16.0.73:143/imap}Inbox",$username,$password); I have also tried $mbox=imap_open("{172.16.0.73:143/imap/novalidate-cert}Inbox",$username,$password); Is there something different in the way one should connect to Exch 2010 compared to Exch 2007?. Our Exch administrators sais that Imap is enabled. The response I get from imap_last_error() is "[CLOSED] IMAP connection broken (server response)" Can anyone help? Regards,

Hi, We are looking to use PHPmyFAQ to use as an internal knowledge base and I'm having trouble with getting LDAP and SSO working. The support from the website is very limited. I have it configured with LDAP and this is working fine. When I enable the SSO section, only users who have logged in previously are logged in automatically. From reading on the site it would appear that the only check for SSO is on the username and not domain\username The code below is part of the SSO.php Is anyone able to help me debug the PHP? /** * Checks if the username of the remote user is equal to the login name * * @param string $login Loginname * @param string $pass Password * @param array $optionalData Optional data * * @return boolean */ public function checkPassword($login, $pass, Array $optionalData = null) { if (!isset($_SERVER['REMOTE_USER'])) { return false; } else { // Check if "DOMAIN\user", "user@DOMAIN" or only "user" $remoteUser = explode('\\', $_SERVER['REMOTE_USER']); if (is_array($remoteUser) && count($remoteUser) > 1) { $user = $remoteUser[1]; } else { $remoteUser = explode('@', $_SERVER['REMOTE_USER']); if (is_array($remoteUser) && count($remoteUser) > 1) { $user = $remoteUser[0]; } else { $user = $_SERVER['REMOTE_USER']; } } if ($user === $login) { return true; } else { return false; } } } /** * Returns true, if $_SERVER['REMOTE_USER'] is set. * * @param string $login Loginname * @param array $optionalData Optional data * * @return boolean */ public function checkLogin($login, Array $optionalData = null) { return isset($_SERVER['REMOTE_USER']) ? true : false; } } Thanks, Michael

$session_start(); echo "test" if ($_SESSION['status'] == 8) { echo "never gets this far Grrrr."; } else { echo "</pre><table>"; echo ""; echo "form stuffform stuff"; echo ""; echo ""; echo "non form stuffnon form stuff "; echo "</table>";<br> $_SESSION['status'] = 8;<br> echo $_SESSION['status'];<br> }<br>?&g Okay, I'm trying to write a new asset management database for the school. I am using a WAMP environment on Windows 2003 R2 in a M$ Virtual Server VM. Everything has been going swimmingly until I hit upon this problem I just can't see the answer to. The above is a heavily edited version of the script causing me problems. On the first pass: 'test', the table and form contents, and '8' are displayed on the screen. When you click on the 'ADD' button to initiate the second pass I get a: HTTP 500 error. Now, the address in the form action is correct. If I change it to another page in the same folder the 'ADD' button works. But when it is asked to reload this page, it doesn't! I have used the same basic code on around half dozen pages without problem. The only other thing of significance is that I am posting around 10 variables from the form this time. That said I have another script that can dynamically post 10's (100's) of variables from it's form and that works without error. Anyone got any pointers, something I should be looking at/for to resolve this strange problem? Cheers Terry.

Hi, I have a word document on the intranet, what is a template. I want to be able to add merge data from the mySql database so when the user selects the name from the drop down box and selects go it will fill in the associated data onto the word document and show on the screen where they can save it, print it ... Any pointers, please let me know, Stuart

I've set this up slightly wrong - when an email is rejected it works fine but sends to the admin email address (like it does when one is created) I would rather a reject email is sent to the person who requested the room! anybody know where i've gone wrong.

Ok, so I've just set up my first apache server running under windows and I'm very new to all this. I've configure everything to make it accessible externally and installed PHP V5.2.17 and Ajaxplorer V4.0.4. Now, by default, it would appear that PHP limits the maximum upload to 2Mb but this is too small for me, so after some research I have altered the PHP settings to change the maximum upload size but it hasn't worked... Any ideas? I have altered the following sections of the PHP file with no luck: memory_limit upload_max_filesize and post_max_size Ajaxplorer doesn't have any limits, this is set purely by PHP as stated on their website. I have uploaded the ini as a text file if this would be any help to anyone to help me and my test PHP can be accessed here. All changes appear to be displayed in here (The values are set quite high as I have tested from 10mb up to 100GB). If you would like to login to the ajaxplorer to view it if this might help it can be accessed here Username: test Password: test123 I've restarted apache and the server various times after changes were made. Any help appreciated - and I'm new to PHP and apache so please consider that in your answers php.txt

My brother came up with a little plan for a X Factor voting app and Im working on the coding but wondered if anyone else had made one and was willing to answer a few questions about using FBML calls in an Iframe app. regards Simon

Hi, We use wordpress for our main webiste, Dont ask long story! I have had to migrate the website onto another server. I get this error message when i try to get into the backend URL REMOVED AT REQUEST I have looked on the net but cant find anything, if anyone has any ideas i would appreciate it Thanks Z PS: I know that it has many errors but we have had to put it live quickly (another long story)

Hi I am looking at using a datagrid for some PHP development, and was looking for an asp.net style datagrid that was available under gpl/open license. I found this dhtmlxGrid - Ajax-enabled DHTML grid with rich Javascript API does anyone know of similar or have feedback on using this tool. Thanks, Tim

Hi guys, Im trying to find a free helpdesk & Ticketing system where we are able to fully customise it to our needs. Thanks Stuart

We have a school website which needs to be able to send information at the server side to paypal. The problem is that all traffic on http or https needs to go via our web server, something which apache obviously doesn't do. Is there a way of doing this in the php script itself?

I long in as Administrator and created a new user with a password .the user details are storing in database.when ever i'm trying to log in with that new user login id and with that password.I'm not able to login.[please help me...

Hi, Does anybody have any suggestions for a weather API? It needs to be able to do historical look up for a specific post code. An added benefit would be free as well! Thanks Chris

Hi, At present the PHP page reads the MySQL data and prints on screen and if the result if 'FREE' it shows a clickable image for the user to book. I am looking for something that allows the user to drag the result they fund to another location with in the table. I.e. user has box 1 filled with their name, they can drag their name to box 9 and it saves it, so they can go back on the it will be their. If anyone knows where I can firn maybe a tutorial, or guide to get started with this, as I have looked and cannot see anything. Cheers. Stu

I keep seeing examples online where usernames and passwords are stored in plaintext using PHP script in a file such as connection.php. Is this safe if pulling website content from a database or will potential attackers be able to read the source-code?

I'm trying to make the display of computers not being used as mentioned in another thread. I am using Webmans Login tracker for the script and database but I've got an error in the Mysql syntax which i can't seem to work out. $computer = mysql_query("SELECT hostname_id FROM logins WHERE active = 1"); $computer_f = mysql_fetch_array($computer); $computer_f_id = $computer_f['hostname_id']; $lib = mysql_num_rows(mysql_query("SELECT hostname FROM hostnames WHERE hostname LIKE 'lib-%' AND hostname_id = $computer_f_id")or die(mysql_error()));