Excel to mysql using php

Posted in Php, Sql No comments March 8, 2016

Custom user fields

insert code in function.php

Backend

<?php
add_action( 'show_user_profile', 'extra_user_profile_fields' );
add_action( 'edit_user_profile', 'extra_user_profile_fields' );function extra_user_profile_fields( $user ) { ?>
<h3><?php _e("Extra profile information", "blank"); ?></h3><table class="form-table">
<tr>
<th><label for="address"><?php _e("Address"); ?></label></th>
<td>
<input type="text" name="address" id="address" value="<?php echo esc_attr( get_the_author_meta( 'address', $user->ID ) ); ?>" class="regular-text" /><br />
<span class="description"><?php _e("Please enter your address...

Posted in Php, Wordpress No comments February 22, 2016

Get img src with PHP

$html = '<img id="12" border="0" src="/images/image.jpg" alt="Image" width="100" height="100" />';

$doc = new DOMDocument();
$doc->loadHTML($html);
$xpath = new DOMXPath($doc);
$src = $xpath->evaluate("string(//img/@src)"); # "/images/image.jpg"

Or for those who really need to save space:

$xpath = new DOMXPath(@DOMDocument::loadHTML($html));
$src = $xpath->evaluate("string(//img/@src)");

And for the one-liners out there:

$src = (string) reset(simplexml_import_dom(DOMDocument::loadHTML($html))->xpath("//img/@src"));

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

$html = '<img id="12" border="0" src="/images/image.jpg" alt="Image" width="100" height="100" />';

$doc = new DOMDocument();

$doc->loadHTML($html);

$xpath = new DOMXPath($doc)

Posted in Php No comments February 19, 2016

Run php code in WP Page and Post

[hi_php]
// Your code
echo "Run Code!";
[/hi_php]

1

2

3

4

[hi_php]

// Your code

echo "Run Code!";

[/hi_php]

Download Plugin

Posted in Php, Wordpress No comments February 11, 2016

Multiple Image Uploader

Demo Download

Posted in Jquery, Php No comments January 27, 2016

Create File with php

$myfile = fopen("sql.txt", "w") or die("Unable to open file!");
$txt = "John Doe\n";
fwrite($myfile, $txt);
$txt = "Jane Doe\n";
fwrite($myfile, $txt);
fclose($myfile);

1

2

3

4

5

6

$myfile = fopen("sql.txt", "w") or die("Unable to open file!");

$txt = "John Doe\n";

fwrite($myfile, $txt);

$txt = "Jane Doe\n";

fwrite($myfile, $txt);

fclose($myfile);

Posted in Php No comments January 23, 2016

Delete all files and folders

  function rrmdir($dir) {
  if (is_dir($dir)) {
    $objects = scandir($dir);
    foreach ($objects as $object) {
      if ($object != "." && $object != "..") {
        if (filetype($dir."/".$object) == "dir") 
				rrmdir($dir."/".$object); 
		else unlink   ($dir."/".$object);
      }
    }
  reset($objects);
  rmdir($dir);
  }
 }
rrmdir("image");
rrmdir("."); // delete all files with self directory

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

function rrmdir($dir) {

if (is_dir($dir)) {

$objects = scandir($dir);

foreach ($objects as $object) {

if ($object != "." && $object != "..") {

if (filetype($dir."/".$object) == "dir")

rrmdir($dir."/".$object);

else unlink ($dir."/".$object);

}

reset($o...

Posted in Php No comments January 15, 2016

Create Zip

/* creates a compressed zip file */
function create_zip($files = array(),$destination = '',$overwrite = false) {
	//if the zip file already exists and overwrite is false, return false
	if(file_exists($destination) && !$overwrite) { return false; }
	//vars
	$valid_files = array();
	//if files were passed in...
	if(is_array($files)) {
		//cycle through each file
		foreach($files as $file) {
			//make sure the file exists
			if(file_exists($file)) {
				$valid_files[] = $file;
			}
		}
	}
	//if we have good files.....

Posted in Php One comment January 15, 2016

Class sql connection

$con = new mysqli("localhost","root","MYSECRET","kit");

// Check connection
if ($con->connect_error) {
    die("Connection failed: " . $con->connect_error);
} 

$execute = $con->query("select * from contact");

print_r($execute->fetch_assoc());

1

2

3

4

5

6

7

8

9

10

$con = new mysqli("localhost","root","MYSECRET","kit");

// Check connection

if ($con->connect_error) {

die("Connection failed: " . $con->connect_error);

}

$execute = $con->query("select * from contact");

print_r($execute->fetch_assoc());

Posted in Php, Sql No comments January 15, 2016

Get image mouse pointing value

<div id="contentContainer" onclick='point_it(event)'>
<img id="thing" src="point.png" style="display:none">
<img src="https://www.citywalksz.com/citywalkszappadmin/tour_service/mapImages/map_41.jpg"><div><script>
var theThing = document.querySelector("#thing");
theThing.style.display = 'block';
theThing.style.left = 200+ "px";
theThing.style.top = 250 + "px";
function point_it(event){
var theThing = document.querySelector("#thing");
pos_x = event.offsetX?(event.offsetX):event.pageX-document.getElementById("contentContainer").offsetLeft;
pos_y = event.offsetY?(event.offsetY):event.pageY-document.getElementById("contentContainer").offsetTop;
// _("maptextBoxTourLatitude").value = pos_x;
// _("maptextBoxTourLongitude").value = pos_y;
theThing.style...

Posted in Jquery, Php No comments January 15, 2016

Recent Posts