php « BrakertechBrakertech

php mysql update variable

posted this in Admin, MYSQL, php, Wordpress on December 4th, 2012

Goal: Update wordpress post with PHP cli

< ?php

$con = mysql_connect("localhost","root","[redacted]");
if (!$con)
  {
 echo "Unable to connect to DB: " . mysql_error();
    exit;
  }
 if (!mysql_select_db("wordpress")) {
    echo "Unable to select mydbname: " . mysql_error();
    exit;
  }
$myfileText = mysql_real_escape_string(file_get_contents('./code_for_wordpress.html',true));

$sql = "UPDATE `[your_instance_prefix]_posts` SET `post_content` = '$myfileText' WHERE `ID` like '1397';";
$result = mysql_query($sql);
 if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
  }

mysql_close($con);
?>

< ?php

$con = mysql_connect("localhost","root","[redacted]");

if (!$con)

{

echo "Unable to connect to DB: " . mysql_error();

exit;

}

if (!mysql_select_db("wordpress")) {

echo "Unable to select mydbname: " . mysql_error();

exit;

}

$myfileText = mysql_real_escape_string(file_get_contents('./code_for_wordpress.html',true));

$sql = "UPDATE `[your_instance_prefix]_posts` SET `post_content` = '$myfileText' WHERE `ID` like '1397';";

$result = mysql_query($sql);

if (!$result) {

echo "Could not successfully run query ($sql) from DB: " . mysql_error();

exit;

}

mysql_close($con);

nginx php centos6 howto

posted this in Linux, nginx, php, Redhat Centos on May 15th, 2012

Remove previous php installation

# yum remove php-cli php-common

1	# yum remove php-cli php-common

Add the EPEL and REMI repos:

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-7.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-7.noarch.rpm

wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

Install nginx prerequisites

# yum install perl pcre-devel gperftools-devel geoip geoip-devel

1	# yum install perl pcre-devel gperftools-devel geoip geoip-devel

Download nginx

# wget "http://nginx.org/download/nginx-1.2.1.tar.gz"

1	# wget "http://nginx.org/download/nginx-1.2.1.tar.gz"

Nginx configuration & installation:

# ./configure --prefix=/etc/nginx/ --sbin-path=/usr/sbin/nginx --conf-path=/etc/nginx/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/run/nginx.pid --lock-path=/var/run/nginx.lock --http-client-body-temp-path=/var/cache/nginx/client_temp --http-proxy-temp-path=/var/cache/nginx/proxy_temp --http-fastcgi-temp-path=/var/cache/nginx/fastcgi_temp --http-uwsgi-temp-path=/var/cache/nginx/uwsgi_temp --http-scgi-temp-path=/var/cache/nginx/scgi_temp --user=nginx --group=nginx --with-http_ssl_module --with-http_realip_module --with-http_addition_module --with-http_sub_module --with-http_dav_module --with-http_flv_module --with-http_mp4_module --with-http_gzip_static_module --with-http_random_index_module --with-http_secure_link_module --with-http_stub_status_module --with-mail --with-mail_ssl_module --with-file-aio --with-ipv6 --with-cc-opt='-O2 -g' --with-http_geoip_module --with-google_perftools_module
# make
# make install

# ./configure --prefix=/etc/nginx/ --sbin-path=/usr/sbin/nginx --conf-path=/etc/nginx/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/run/nginx.pid --lock-path=/var/run/nginx.lock --http-client-body-temp-path=/var/cache/nginx/client_temp --http-proxy-temp-path=/var/cache/nginx/proxy_temp --http-fastcgi-temp-path=/var/cache/nginx/fastcgi_temp --http-uwsgi-temp-path=/var/cache/nginx/uwsgi_temp --http-scgi-temp-path=/var/cache/nginx/scgi_temp --user=nginx --group=nginx --with-http_ssl_module --with-http_realip_module --with-http_addition_module --with-http_sub_module --with-http_dav_module --with-http_flv_module --with-http_mp4_module --with-http_gzip_static_module --with-http_random_index_module --with-http_secure_link_module --with-http_stub_status_module --with-mail --with-mail_ssl_module --with-file-aio --with-ipv6 --with-cc-opt='-O2 -g' --with-http_geoip_module --with-google_perftools_module

# make

# make install

PHP installation:

# yum --enablerepo=remi,remi-test install php php-fpm php-common php-pear php-pecl-apc php-pdo php-mysql php-pgsql php-pecl-memcache php-gd php-mbstring php-mcrypt php-xml php-ldap php-pecl-geoip

1	# yum --enablerepo=remi,remi-test install php php-fpm php-common php-pear php-pecl-apc php-pdo php-mysql php-pgsql php-pecl-memcache php-gd php-mbstring php-mcrypt php-xml php-ldap php-pecl-geoip

Edit Nginx configuration:

#sudo nano -w /etc/nginx/nginx.conf

--Sample Configuration

user nginx;
worker_processes 1;

error_log /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;

events {
worker_connections 1024;
}

http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';

access_log /var/log/nginx/access.log main;

## Proxy
proxy_redirect off;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
client_max_body_size 10m;
client_body_buffer_size 128k;
proxy_connect_timeout 90;
proxy_send_timeout 90;
proxy_read_timeout 90;
proxy_buffers 8 16k;
proxy_buffer_size 32k;

## Compression
gzip on;
gzip_types text/plain text/css application/x-javascript
text/xml application/xml
application/xml+rss text/javascript;
gzip_disable "MSIE [1-6].(?!.*SV1)";

### TCP options
tcp_nodelay on;
tcp_nopush on;
keepalive_timeout 10;
sendfile on;

# include /etc/nginx/conf.d/*.conf;
include /etc/nginx/sites-enabled/*;
}

#sudo nano -w /etc/nginx/nginx.conf

--Sample Configuration

user nginx;

worker_processes 1;

error_log /var/log/nginx/error.log warn;

pid /var/run/nginx.pid;

events {

worker_connections 1024;

}

http {

include /etc/nginx/mime.types;

default_type application/octet-stream;

log_format main '$remote_addr - $remote_user [$time_local] "$request" '

'$status $body_bytes_sent "$http_referer" '

'"$http_user_agent" "$http_x_forwarded_for"';

access_log /var/log/nginx/access.log main;

## Proxy

proxy_redirect off;

proxy_set_header Host $host;

proxy_set_header X-Real-IP $remote_addr;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

client_max_body_size 10m;

client_body_buffer_size 128k;

proxy_connect_timeout 90;

proxy_send_timeout 90;

proxy_read_timeout 90;

proxy_buffers 8 16k;

proxy_buffer_size 32k;

## Compression

gzip on;

gzip_types text/plain text/css application/x-javascript

text/xml application/xml

application/xml+rss text/javascript;

gzip_disable "MSIE [1-6].(?!.*SV1)";

### TCP options

tcp_nodelay on;

tcp_nopush on;

keepalive_timeout 10;

sendfile on;

# include /etc/nginx/conf.d/*.conf;

include /etc/nginx/sites-enabled/*;

}

Create your web folder eg: /srv/www and change the owner of the folder:

– Create Directory

# cd /srv
# mkdir www

1 2	# cd /srv # mkdir www

– Change ownership

# sudo chown -R nginx:nginx /srv/www

1	# sudo chown -R nginx:nginx /srv/www

Sample vhost configuration:

. . . → Read More: nginx php centos6 howto

Brakertech

php mysql update variable

nginx php centos6 howto

Search Brakertech

dEFENSE

Hacking

Security

Brakertech

php mysql update variable

nginx php centos6 howto

Search Brakertech

dEFENSE

Hacking

Tags

Security