database related links in php

database create in php with mysql
create table in php with mysql
select in php with mysql
search data in table with user inputs in php with mysql
where in php with mysql
update in php with mysql
order by in php with mysql
insert data into table in php with mysql
delete table in php with mysql
connect with database in php with mysql

some php related quick links

data types related links

arrays related links

database related links in php

DATA TYPES RELATED LINKS IN PHP

compound data types in php
special data types in php
scalar data types in php

ARRAYS RELATED LINKS IN PHP

array
arrays display
associative arrays in php
multi dimensional arrays in php
for each statements with arrays in php
add one arry to another array or append
array reduce with array_splice() in php
array to string in php
change array size using array_pad() in php
delete array elements with unset() in php
check array index or key with user inputs in php
checking if an element is in array or not using in php

imagecreate() or image create in php

<?php
header("Content-Type: image/png");
$img = @imagecreate(110, 20)
  or die("you Can't Initialize new GD image stream");
$background_color = imagecolorallocate($img, 0, 0, 0);
$text_colour = imagecolorallocate($img, 233, 14, 91);
imagestring($img, 1, 5, 5, "hai how are you", $text_colour);
imagepng($img);
imagedestroy($img);
?>

scandir() in php

scan.php :

<?php
@print_r(scandir("send"));
?>


output :

Array ( [0] => . [1] => .. [2] => send_vard.php [3] => send_vcard_sms.html [4] => sendsms.html [5] => sendsms.php [6] => smser.php )

reset a directory with rewinddir() in php

 rewinddir.php :

<?php

//Open send directory
if(@$dir = opendir("send"))
{

//List files in send directory
while (($file = readdir($dir)) !== false)
{
echo "filename: " . $file . "<br />";
}

//resets the directory stream
rewinddir($dir);

//to check for changes

closedir($dir);
}
else
{
echo 'directory not opened';
}
?>

outputs :
 1)
directory not opened

2)


filename: .
filename: ..
filename: sendsms.html
filename: sendsms.php
filename: send_vard.php
filename: send_vcard_sms.html
filename: smser.php

readdir() in php

<?php
//Open send directory

if(@$dir = opendir("send"))

{//List files in send directory

while (($file = readdir($dir)) !== false)

{

echo "filename: ". $file ."<br />";

}

closedir($dir);

}

else

{

echo 'directory not opened';

}

?>

outputs :
 1)
directory not opened

2)
filename: .
filename: ..
filename: sendsms.html
filename: sendsms.php
filename: send_vard.php
filename: send_vcard_sms.html
filename: smser.php

opens a directory with opendir() in php

open.php :

<?php
//Open send directory
if(@$dir = opendir("send"))
{
//List files in send directory
while (($file = readdir($dir)) !== false)
{
echo "filename: " . $file . "<br />";
}
closedir($dir);
}
else
{
echo 'directory not opened';
}
?>

output :
 1)
directory not opened

2)
filename: .
filename: ..
filename: sendsms.html
filename: sendsms.php
filename: send_vard.php
filename: send_vcard_sms.html
filename: smser.php

current directory with getcwd() in php

getcwd.php :

<?php
echo getcwd();
?>

output :

E:\xampp\htdocs\1

open files in a directory with dir() in php

<?php
//Open send directory
if(@$dir = @dir("send"))
{
//List files in send directory
while (($file = $dir->read()) !== false)
{
echo "filename: " . $file . "<br />";
}
$dir->close();
}
else
{
echo 'directory not opened';
}
?>

output :
 1)
directory not opened

2)
filename: .
filename: ..
filename: sendsms.html
filename: sendsms.php
filename: send_vard.php
filename: send_vcard_sms.html
filename: smser.php

note :
"send" is a directory name

getcwd() and chdir() in php

<?php

//to Get current directory

echo '<br>current directory<br> '.getcwd()."<br />";

//Change to send directory

if(@chdir("send"))
echo '<br>directory changed to<br> '.getcwd();
else
echo '<br>directory not changed<br>';

?>

output :

current directory
C:\xampp\htdocs\1

directory changed to
C:\xampp\htdocs\1\send

when opendir() using it close with closedir() in php

closedir.php :

<?php

//Open send directory
if(@$dir = opendir("send"))
{
echo '<br>dir opened<br>';

//List files in send directory
while (($file = readdir($dir)) !== false)
{
echo "filename: " . $file . "<br />";
}
closedir($dir);
echo '<br>dir closed<br>';
}
else
echo 'directory not opened';
?>
=========================================
outputs :
 1)
directory not opened

2)
dir opened
filename: .
filename: ..
filename: sendsms.html
filename: sendsms.php
filename: send_vard.php
filename: send_vcard_sms.html
filename: smser.php

dir closed