PHP4IT.com - Information Technology Solutions via PHP!

Welcome to PHP4IT where you'll find php code samples & php scripts geared towards solving common (& not so common) problems in IT. Any comments/corrections are 100% welcome so please feel free to speak up!

PHP Forum
NavCurrent TopicsRepliesViewsRatingPosterDateTime
 ZendCon 2010 Registration Now Open Registration is now open for the annual Zend/PHP Conference, ZendCon 2010, the....014089
+56
David08/1612:52
 Zend Studio 7.1 Released Zend announced the immediate availability of Zend Studio 7.1, which adds significant....021809
+43
David12/0413:12
 Zend Server on Oracle Unbreakable Linux Network Zend today announced that it is working with Oracle to deliver an....015881
+44
David11/0410:48
 Zend Simple API for Cloud Application Services Unveiled Zend Technologies, the PHP Company, today launched the Simple API for Cloud....015294
+48
David09/2217:03
 Zend Framework 1.9 and Zend Studio 7.0 Released Zend Technologies today announced that the widely successful open source project Zend....026142
+38
David07/2911:42
 PHP 5.3.0 Released The PHP development team is proud to announce the immediate release of....018935
+45
David06/3010:32
 PHP 5.2.10 Released The PHP development team would like to announce the immediate availability of....019798
+49
David06/1901:22
 Zend Server Community Edition Unveiled Zend announced today the general availability of Zend Server Community Edition, a....019988
+30
David04/0703:11

[View PHP Forum]


Guide to Getting PHP 5 to work with IIS 6 with custom identity

Posted by: David on Friday/April 04/2008 - 02:50 PM
Windows Php 
When you want PHP running in IIS to be able to read/write files on a Windows network share, you could run into a myriad of errors and problems. Hopefully this article will help you get everything working smoothly.

Here what we want is to have IIS run as a Domain user who has the proper access to the network share. After you have installed PHP (in ISAPI mode), go to the IIS Manager, Application Pools, right-click on DefaultAppPool (or the name of your application pool), and select Properties. Go to the Identity tab and type in the User name and Password for the Domain user. Don't forget to prefix the username with the Domain. For instance (and for our example's sake):

MY_DOMAIN\my-user

Click OK and you will be asked to confirm the password again.

Now you'll want to make sure that you go to the server that has the target directory share and make sure all the permissions are set so that that MY_DOMAIN\my-user has the proper read or read/write permissions to that share.

Now back on the IIS server, go to Administrative Tools, Computer Management, expand Local Users and
Groups, go to Groups, and double-click on IIS_WPG (IIS Worker Process Group). You must add MY_DOMAIN\my-user to the group or else you may end up with the "Service Unavailable" message when you try to load the website.

Next go to Administrative Tools, Local Policies, and User Rights Assignment. Add MY_DOMAIN\my-user to the following policies of "Access this computer from the network", "Act as part of the operating system", and "Log on as a service".

Now go to the Properties of your website ("Default Web Site"), go to the Directory Security tab, and click on the Edit button for "Authentication and access control". If you have enabled anonymous access, make sure that the user name is set to MY_DOMAIN\my-user and the password is inputted correctly.

Restart IIS and voila, everything should work. If not make sure you check the Event Viewer on the destination server and see if the error messages there give you any clue as to why it's not working. If it doesn't work and you see Microsoft Authentication Security Account Logon Failure, then it's an issue with the user name and password specified there.

In your PHP script make sure that you escape backslashes for the network share you're trying to get to. For instance if you're tring to do a "opendir" on "\\my_server\my_files", you would do:

$dh = opendir("\\\\my_server\\my_files");

If you get PHP undefined function errors such as:

Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\your_script.php

make sure you enabled the module (in this case extension=php_mysql.dll) in php.ini. If you did, it could well be that PHP is not reading the php.ini for some reason. You can make sure by looking at the output of php_info() and look for "Loaded Configuration File". If it says "(none)", then there's a problem. Make sure that "MY_DOMAIN\my-user" (in our example) has read permissions to the php.ini file AND the directory in which it resides- whether it be C:\PHP or C:\Windows.

If you have trouble executing commands using exec(), passthru(), etc, and the script seems to hang, make sure you have given the proper permissions to cmd.exe. So make sure that c:\windows, c:\windows\system32, and cmd.exe all can be read and executed by, in our example, MY_DOMAIN\my-user.

Good luck and I hope this guide helps. These instructions could work for other PHP and Microsoft Internet Information Server (IIS) versions as well, though I used PHP 5.2 and IIS 6.

Discuss/Submit Comment | Email This

Securing the Recommend Us feature in PostNuke/PHP Nuke

Posted by: David on Friday/March 28/2008 - 04:00 PM
Php Security 
I've noticed some oddball email bounces stemming from the Recommend_Us module trying to send email to non-existent email addresses. A lot of them would contain spam words which I won't list here. I came to the conclusion that this is a malicious attack on a PostNuke/PHP Nuke site trying to blacklist the server hosting the site as a source of spam. Therefore I think it is important that if you run a PostNuke or PHPNuke site that you take steps to secure the "Recommend Us" module. Since I am running PostNuke, the solution here is based for that CMS, but the same concepts apply for PHP Nuke.

Basically we want to make sure that a user is logged in before he/she can recommend the site/story from the site.

Here are the steps:

  • head over to your root PostNuke directory, go to modules, and Recommend_Us.

  • Make a backup copy of index.php

  • Edit the file index.php.

  • Look for instances of:


  • if (pnUserLoggedIn()) {

    and in the else portion, put in something like the following:

    die("You must be a member and logged in to send a recommendation.");

    Note that some already have the "else" and some you will have to add yourself.

  • Next I would recommend changing the text input boxes for "Your name" and "Your email" into hidden inputs instead. For instance, change:

    echo "
    <table>
    <tr>
    <td><span class=\"pn-normal\"><label for=\"YOURNAME\">"._FYOURNAME."</label></span></td>
    <td><input type=\"text\" name=\"yname\" value=\"$yn\" SIZE=\"25\" maxlength=\"25\" id=\"YOURNAME\" tabindex=\"0\" /></td>
    </tr>
    <tr>
    <td><span class=\"pn-normal\"><label for=\"YOUREMAIL\">"._FYOUREMAIL."</label></span></td>
    <td><input type=\"text\" name=\"ymail\" value=\"$ye\" size=\"25\" id=\"YOUREMAIL\" tabindex=\"0\" /></td>
    </tr>


    to

    echo "<table>
    <input type=hidden name=\"yname\" value=\"$yn\"> <input type=hidden name=\"ymail\" value=\"$ye\">


  • And voila you have just secured the recommendation feature from anonymous malicious users.

    Discuss/Submit Comment | Email This

    Adding the DBF dbase extensions in Red Hat Linux/Fedora

    Posted by: David on Tuesday/February 07/2006 - 07:40 PM
    Php Db Conversion 

    The previous two articles showed how to convert and import data from DBF files into MySQL. It's simple enough to enable the dbase extension for PHP for Windows, but if you're using Red Hat/Fedora, this is not as simple. There's no rpm that you can simply install to enable the extension, so you have to recompile and build the PHP Redhat/Fedora RPM. Here are the steps to do this (note that this can work with other extensions that you can't find the rpm for):

    1) download the source rpm for PHP, usually it'll have the word "src" in the file name
    2) install it - e.g. "rpm -Uvh php_src.rpm"
    3) edit the php.spec file, usually located in
    /usr/src/redhat/SPECS/php.spec, and add "--enable-dbase"
    4) run rpmbuild - "rpmbuild -ba php.spec"
    5) Go to the directory of the newly created RPMs (e.g. /usr/src/redhat/RPMS/i386/) and install them (note the --force):

    rpm -Uvh --force php-4.3.8-1.1.i386.rpm php-devel-4.3.8-1.1.i386.rpm php-imap-4.3.8-1.1.i386.rpm php-ldap-4.3.8-1.1.i386.rpm php-mysql-4.3.8-1.1.i386.rpm php-pgsql-4.3.8-1.1.i386.rpm php-odbc-4.3.8-1.1.i386.rpm php-snmp-4.3.8-1.1.i386.rpm php-domxml-4.3.8-1.1.i386.rpm php-xmlrpc-4.3.8-1.1.i386.rpm php-mbstring-4.3.8-1.1.i386.rpm php-debuginfo-4.3.8-1.1.i386.rpm

    That should get the job done!



    Discuss/Submit Comment | Email This

    Import/Convert DBF files into MySQL - Part 2

    Posted by: David on Friday/January 20/2006 - 04:31 PM
    Php Db Conversion 
    Here in part 2 we focus on reading from the DBF file (addresses.dbf) and then inserting the data into the MySQL table (in this case a table called "addresses") created from the CREATE TABLE statement generated in part 1.

    Before continuing note that you will need the DBase extensions compiled/loaded. In Windows you simply uncomment out the line:

    ;extension=php_dbase.dll

    In Linux and other *nix you will have to compile PHP with the "--enable-dbase" option.

    The code will look for matching field names as it loops through the entire file and generate & execute INSERT statements in MySQL. Note that I start with record 1 as record 0 doesn't seem to contain actual data when using the dbase_get_record_with_names() function. Here it goes:

    'addresses'); $db_uname = ''; $db_passwd = ''; $db = 'test'; $conn = mysql_p_connect($db_uname, $db_passwd, $db); foreach ($dbf_files as $key => $val){ import_dbf2($db, $val, $key); } function import_dbf2($db, $table, $dbf_file) { global $conn; if (!$dbf = dbase_open ($dbf_file, 0)){ die("Could not open $dbf_file for import."); } $num_rec = dbase_numrecords($dbf); $num_fields = dbase_numfields($dbf); $fields = array(); for ($i=1; $i<=$num_rec; $i++){ $row = @dbase_get_record_with_names($dbf,$i); $q = "insert into $db.$table values ("; foreach ($row as $key => $val){ if ($key == 'deleted'){ continue; } $q .= "'" . addslashes($val) . "',"; } if (isset($extra_col_val)){ $q .= "'$extra_col_val',"; } $q = substr($q, 0, -1); $q .= ')'; //if the query failed - go ahead and print a bunch of debug info if (!$result = mysql_query($q, $conn)){ print (mysql_error() . " SQL: $q
    \n"); print (substr_count($q, ',') + 1) . " Fields total.

    "; $problem_q = explode(',', $q); $q1 = "desc $db.$table"; $result1 = mysql_query($q1, $conn); $columns = array(); $i = 1; while ($row1 = mysql_fetch_assoc($result1)){ $columns[$i] = $row1['Field']; $i++; } $i = 1; foreach ($problem_q as $pq){ print "$i column: {$columns[$i]} data: $pq
    \n"; $i++; } die(); } show_status($i, $num_rec); } } //this function outputs the current progress of the import function show_status($i, $max, $precise_mode=FALSE){ if ($i == floor($max/4)){ print "...25%"; flush(); } if ($i == floor($max/2)){ print "...50%"; flush(); } if ($i == floor($max*0.75)) { print "...75%"; flush(); } if ($i >= $max) { print "...100%
    \n"; flush(); return; } if ($precise_mode){ print '...' . (round($i/$max * 100)) . "%"; flush(); } } ?>

    Discuss/Submit Comment | Email This

    Import/Convert DBF files into MySQL - Part 1

    Posted by: David on Tuesday/January 17/2006 - 08:13 PM
    Php Db Conversion 
    If you've been presented with the task of having to import a Dbase/DBF - here's a two step way to approach the problem. First the Mysql table structure needs to be created, and then the DBF is then read and inserted into the table.

    I'll present step 1 today, which involves the conversion the output from the "disp stru" command in FoxPro into a MySQL create table statement.

    Consider a DBF file called "addresses.dbf"- and the "DISP STRU" of the file looks like this:

    1 HNAME1 Character 30
    2 ADDRESS Character 30
    3 EXTRA Character 30
    4 CITY Character 28
    5 STATE Character 2
    6 ZIP Character 10

    The convert function would convert that to this:

    HNAME1 char (30)
    ADDRESS char (30)
    EXTRA char (30)
    CITY char (28)
    STATE char (2)
    ZIP char (10)

    Here's the script:

    $val){ if (!strlen(trim($val))){ continue; } if (is_numeric($val)){ $newline .= "($val),"; }else{ $newline .= "$val "; } } $newline .= "\n"; } return $newline; } ?>

    Discuss/Submit Comment | Email This

    Login
     



     


    Log in Problems?
    New User? Sign Up!
    New Comments · Re: Printing a form directl... in Printing a form directly to...
    · Re: Printing a form directl... in Printing a form directly to...

    Solutions Categories· All topics
    · Database Import and Conversion with PHP (02/07/2006)
    · PHP Security (03/28/2008)
    · Printing (01/05/2006)
    · Windows PHP Solutions (04/04/2008)
    Cool Sites
  • The Official PHP Site
  • Tech Blog by Dave
  • Cool Computing
  • Search

    PHP News from Around the Net
  • 10 Top PHP Custom Development Services in Australia Ranked by australia ... - Virtual-Strategy Magazine (press release) (Thu., Jul. 24, 2014 02:16 AM CDT): 10 Top PHP Custom Development Services in Australia Ranked by australia ...Virtual-Strategy Magazine (press release)The independent authority on web design and development in Australia, australia.bestwebdesignagencie s.com, has named their rankings of the 10 top PHP web development companies in the web services industry for the month of July 2014. Each month the ...and more » [Read the entire article.]
  • Quick Tip: 4 Steps to Install Custom PHP Extensions into Zend Server 7 - SitePoint (Tue., Jul. 22, 2014 11:39 AM CDT): Quick Tip: 4 Steps to Install Custom PHP Extensions into Zend Server 7SitePointZend Server 7 is an excellent tool for managing, deploying and monitoring your PHP applications. We've covered its installation in this quick tip, and we've given it a somewhat thorough review in this post. In this Quick Tip, we'll go through the ...and more » [Read the entire article.]
  • The Next Version Of PHP And The Status Of PHPng - iProgrammer (Mon., Jul. 21, 2014 11:47 AM CDT): The Next Version Of PHP And The Status Of PHPngiProgrammerSome of the developers of PHPng are calling it PHP 6.0 (they probably mean PHP 7.0) and while other developers are suggesting that it should really be called PHP 5.7, or even that it isn't ready for the main branch at all. The whole matter has been ...and more » [Read the entire article.]
  • 4 ways PHP coding is getting less painful - InfoWorld (Wed., Jul. 2, 2014 05:01 AM CDT): 4 ways PHP coding is getting less painfulInfoWorldIt's easy to hate PHP despite the culture of software built on top of it. InfoWorld even compiled its own list of 12 things about the language that drive developers crazy. But over the past few years, PHP has accrued changes -- to the language itself ... [Read the entire article.]
  • Is PHP 6 or PHP 7 Next? (Mon., Jul. 21, 2014 10:05 AM CDT): From the 'open-source nomenclature' files: [Read the entire article.]
  • OnePlus One A0001 with Snapdragon 801 CPU and LTE support sells on Lazada for around 14K (Wed., Jul. 23, 2014 03:17 AM CDT): Popular smartphones that come with Qualcomm?s Snapdragon 801 quad-core chip are undoubtedly expensive. Specific examples include the HTC One (M8) (PhP 32,990), LG G3 (PhP 35,990), Samsung Galaxy S5 (PhP 34,990), and the Sony Xperia Z1 (PhP 33,990). Looking for more affordable options? Try checking out Oppo?s Find 7 and Find 7a, selling for PhP 25,990 and PhP 22,990 respectively, or the Xiaomi Mi ... [Read the entire article.]
  • Vallum Software Announces Public Availability of Software Development Kit (SDK) and Design Disclosure Document for Its ... (Mon., Jul. 21, 2014 10:08 AM CDT): SDK designed for PHP Developers extends the functionality of Vallum Halo availability management solution enabling creation of new monitor widgets, new processing facilities and rapid development of custom network management functions specific to business requirements. (PRWeb July 21, 2014) Read the full story at http://www.prweb.com/releases/ 2014/07/prweb12031132.htm [Read the entire article.]
  • Zend Studio 11 "Mobilizes" PHP Applications and Boosts Developer Productivity and Flexibility (Tue., Jul. 15, 2014 10:00 AM CDT): CUPERTINO, Calif., July 15, 2014 /PRNewswire/ -- Zend, the PHP company, today announced the general availability of the newest version of Zend Studio, the award-winning integrated development environment ... [Read the entire article.]