▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 PHP4 COM function (windows version) : FULL
PART 3
instagram.com/UndercOdeTestingCompany


"; #Another

way to get the version

$ testversion = com_get ($ word-> application, version);

print" Version using Com_get (): $ testversion
"; #Make

it visible

$ word-> Visible = 1;

# creates a new file

$ Word-> Documents-> the Add ();

# write character

$ Word-> Selection-> TypeText ( "This IS the Test A ...");

# save

$ word-> documents [1] -> the SaveAs ( "Useless test.doc");

# close

$ Word-> the Quit ();

>?

Just take a few minutes to read this program and refer to Word's OLE technical documentation, you will learn almost all the operations you need in your own program.

MS Excel function using PHP's COM

　　As the example above, like Word, you should learn this example also refer to the documentation for Excel Visual Basic Editor Object Browser.


#Open workbook and its sheet,
#This example uses a spreadsheet that is SOLVSAMP.XLS that comes with Excel installation

$ workbook = "C: Program FilesMicrosoft officeOfficeSamplesSOLVSAMP.XLS";
$ sheet = "Quick Tour"; #Instance

a Component object
$ ex = new COM ("Excel.sheet") or Die ("Did not connect"); #Get

program name and version
print "Application name: {$ ex-> Application-> value}
";
print " Loaded version: {$ ex-> Application-> version}

Written by UndercOde
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 PHP4 COM function (windows version) : FULL
PART 4
twitter.com/UNDERCODETC

🦑 𝕃𝔼𝕋𝕊 𝕊𝕋𝔸ℝ𝕋 :

"; #Open workbook

so that we can use it
$ wkb = $ ex-> application-> Workbooks-> Open ($ workbook) or Die (" Did not open " );

# Pre-save the original workbook, create a copy of the workbook
$ ex-> Application->
# $ ex-> Application-> Visible = 1; #This sentence goes to comment to make Excel visible

# Read and write a cell in a new worksheet
# We can read this cell E11 (Advertising in the 4th. Quarter)
$ sheets = $ wkb-> Worksheets ($ sheet); #Select the sheet
$ sheets-> activate; #Activate it
$ cell = $ sheets-> Cells (11,5); #Select the cell (Row Column number)
$ cell-> activate; #Activate the cell
print "Old Value = {$ cell-> value}
"; #Print the value of the cell: 10000
$ cell-> value = 15000; #Change it to 15000
print "New value = {$ cell-> value}
"; #Print the new value = 15000 #Finally

, recalculate this cell with the new value
$ sheets-> Calculate; #Required
if you want to calculate, manual is optional
# Can see Total effect value (cell E13)
$ cell = $ sheets-> Cells (13,5); #Select the cell (Row Column number)
$ number = Number_format ($ cell-> value);
print "New Total cost = $$ number-was $ 47,732 before.
" ;
#According to the calculation formula, the advertisement affects the company's expenses, here will display $ 57,809 #using the

Excel built-in function
# PMT (percent / 12 months, Number of payments, Loan amount)
$ pay = $ ex-> application-> pmt (0.08 / 12,10,10000);
$ pay = sprintf ("%. 2f", $ pay);
print "Monthly payment for $ 10,000 loan @ 8% interest / 10 months: $ $ pay
";

#Should print monthly payment = $ -1,037.03 #Optional

, save
$ ex-> Application-> ActiveWorkbook-> SaveAs ("Ourtest"); #Close
without asking
$ ex-> application-> ActiveWorkbook-> Close ("False");
unset ($ ex);

?>

Written by UndercOde
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑HOSTING BY UNDERCODE TUTORIAL FOR BEGINER
t.me/UnderCodeTesting

🦑 𝕃𝔼𝕋𝕊 𝕊𝕋𝔸ℝ𝕋 :

> httpd.conf file comments for Apache ServerThe reference here is the Apache Server

1) ServerType standalone #Set whether the
server is to be started in standalone mode or by the internet server program inetd. The former is generally used.

2) ServerRoot "d: / Apache" #Set the home
directory of the server, which is used to store server settings files, error files, and log files.

3) PidFile logs / httpd.pid #When the
program starts, save the process ID (process id) of the parent process httpd in this file. This file name can be changed with the PidFile command.

4) ScoreBoardFile logs / apache_status #Set
the log files of some execution programs of the WWW server on the network.

#ResourceConfig conf / srm.conf
#AccessConfig conf / access.conf #The
contents of these two files are already included in the httpd.conf file.

5) Timeout 300 #If the
client has not been connected for 300 seconds, or the server has not transmitted data to the client for 300 seconds, it will automatically disconnect.

6) KeepAlive On #Set
whether to support the resume function.

7) MaxKeepAliveRequests 100 #Set
the number of functions that support resume transmission . The larger the number, the more hard disk space is wasted. Set to 0 for more than continuous transmission.

8) KeepAliveTimeout 15 #If
the user has not sent a request to the server after 15 seconds, then he cannot resume the transmission.

9) MaxRequestsPerChild 0
#Set the number of child processes in the same time.

ThreadsPerChild 50 #Set
the number of processes used by the server.

#Listen 3000
#Listen 12.34.56.78:80 #Allow
access to the server using another port or IP. In this example, the Port is 3000 and the IP is 12.34.56.78:80.

#BindAddress * #Set
Apache to listen on all IP, you can also specify it specifically.

#LoadModule anon_auth_module modules / ApacheModuleAuthAnon.dll
... #Open
the module that is not currently active.

#ExtendedStatus On #Set
the status information generated by the server.


🦑 The reference here is the Apache Server1_3_12_win32 version.

Port 80 #Set the port
used by the server.

ServerAdmin you@your.address #Set
the E-Mail address of the server administrator.

#ServerName new.host.name
#Host name of the server. If you have a fixed IP address, you don't need to set it.

DocumentRoot "d: / Apache / htdocs" #Set
the directory where the html files of the site are stored.

<Directory />
Options FollowSymLinks
AllowOverride None
</ Directory>

🦑 # Set / Directory directive. Specifically:
Option: defines the operations that can be performed in the directory. None means that you can only browse. FollowSymLinks allows pages to be connected elsewhere. ExecCGI allows CGI to be performed. MultiViews allows you to watch animations or listen to music. Indexes allows the server to return a formatted list of directories. Includes allows SSI. These settings can be checked. All can do anything but excludes MultiViews.
AllowOverride: Adding the None parameter means that anyone can browse the files in this directory. Other parameters are: FileInfo, AuthConfig, Limit.

UserDir "d: / Apache / users /"
#Define the directory where users store html files.

DirectoryIndex index.html #Defines
the file to be displayed first.

AccessFileName .htaccess #Define
the name of the access control file for each directory.

#CacheNegotiatedDocsDefines the
proxy server not to cache your pages. Not recommended for use.

UseCanonicalName On #The
server uses the server name specified by ServerName and the port address specified by Port.

WRITTEN BY UNDERCODE
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 Apache Server's httpd.conf file commentsThe reference here is the Apache Server.._win32 version- OLD STABLE VERSION
twitter.com/undercodeNews

🦑𝕃𝔼𝕋' 𝕊 𝕊𝕋𝔸ℝ𝕋 :


1) ServerType standalone #Set whether the
server is started separately (standalone) or through the internet server inetd. The former is generally used.

2) ServerRoot "d: / Apache" #Set the
server's Home directory to store the server's configuration files, error files, and log files.

PidFile logs / httpd.pid #When the
program starts, store the process ID of the parent process httpd in this file. This file name can be changed with the PidFile command.

3) ScoreBoardFile logs / apache_status #Set
the log files of some execution programs of the WWW server on the network.

#ResourceConfig conf / srm.conf
#AccessConfig conf / access.conf #The
contents of these two files are already included in the httpd.conf file.

Timeout 300 #If the
client has not been connected for 300 seconds, or the server has not transmitted data to the client for 300 seconds, it will automatically disconnect.

KeepAlive On #Set
whether to support the resume function.

MaxKeepAliveRequests 100 #Set
the number of resume transmission functions. The larger the number, the more wasted hard disk space. Set to 0 for more than continuous transmission.

KeepAliveTimeout 15 #If
the user has not sent a request to the server after 15 seconds, he cannot resume the transmission.

MaxRequestsPerChild 0
#Set the number of child processes at the same time.

ThreadsPerChild 50 #Set
the number of processes used by the server.

#Listen 3000
#Listen 12.34.56.78:80 #Allow the
use of other ports or IPs to access the server. In this example, the Port is 3000 and the IP is 12.34.56.78:80.

#BindAddress * #Set
Apache to listen to all IPs, which can also be specified specifically.

#LoadModule anon_auth_module modules / ApacheModuleAuthAnon.dll
...... #Open
the module that is not currently activated for reservation.

#ExtendedStatus On #Set
the status information generated by the server.


The reference here is the Apache Server1_3_12_win32 version.

Port 80 #Set the port
used by the server.

ServerAdmin you@your.address #Set
the E-Mail address of the server administrator.

#ServerName new.host.name
#Host name of the server. If you have a fixed IP address, you do not need to set it.

DocumentRoot "d: / Apache / htdocs" #Set
the directory for storing site html files.

<Directory />
Options FollowSymLinks
AllowOverride None
</ Directory>
# Setup / Directory instructions. Specifically:
Option: defines the operations that can be performed in the directory. None means you can only browse, FollowSymLinks allows the page to connect to other places, ExecCGI allows you to perform CGI, MultiViews allows operations such as watching animation or listening to music, Indexes allows the server to return a formatted list of directories, and Includes allows the use of SSI. These settings can be checked. All can do anything, but does not include MultiViews.
AllowOverride: Add None parameter to indicate that anyone can browse the files in this directory. Other parameters are: FileInfo, AuthConfig, Limit.

UserDir "d: / Apache / users /"
#Define the directory where users store html files.

DirectoryIndex index.html #Define
the file to be displayed first.

AccessFileName .htaccess #Define
the name of each directory access control file.

#CacheNegotiatedDocs
Define that the proxy server should not cache your pages. Not recommended for use.

UseCanonicalName On #The
server uses the server name specified by ServerName and the port address specified by Port.

written by undercoders

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁