How to convert from CSV file into MySQL database using PHP?
Plus how to create a table and fields into database with PHP?
Here it is..
We need 3 files php, and 2 file jpg (the jpg is just for menu).
index.php
http://jawaad.pastebin.com/f6399baf4
upload_csv.php
http://jawaad.pastebin.com/f2c7bdbee
create_table.php
http://jawaad.pastebin.com/f64b250cc
And image files:
Converting hex into a text or normal string.
PHP CODE
function hex2text($hexstr) {
$hex = explode('%',$hexstr);
array_shift($hex);
$str = '';
foreach($hex as $hexcode) {
$str .= chr(base_convert($hexcode, 16, 10));
}
return $str;
}
Here is how to insert file BLOB MySQL.
PHP CODE:
if($_POST[submit]){
$file_name = $_FILES['file']['name'];
$tmp_name = $_FILES['file']['tmp_name'];
$file_size = $_FILES['file']['size'];
$file_type = $_FILES['file']['type'];
$fp = fopen($tmp_name, 'r');
$file_content = fread($fp, $file_size) or die("Error: cannot read file");
$file_content = mysql_real_escape_string($file_content) or die("Error: cannot read file");
fclose($fp);
// INSERT
$qu = "INSERT INTO `file`
(`file_content`,`file_name`,`file_type`,`file_size`)
VALUES
('$content','$file_name','$file_type','$file_size')";
$re = mysql_query($qu) or die ("Sorry Cant insert db!");
echo $file_name." inserted succesfully to database";
}
echo "< form method=\"post\" name=\"form1\" enctype=\"multipart/form-data\">";
echo " < input name=\"file\" type=\"file\">";
echo " < input name=\"submit\" type=\"submit\" value=\"Upload\">";
echo "< /form>";
Submit once even the visitor is refresh the page from browser.
Here is the way to protect.
Use a SESSION.
1. Set a session in the form page
session_start();
$_SESSION[post_only_once] = 1;
echo "
< form method=\"post\">
Name < input type=\"text\" name=\"name\">
< input type=\"submit\" value=\"submit\" name=\"submit\">
< /form>
";
session_start();
if($_SESSION[post_only_once] == 1) {
// here doing insert to mysql
}
unset($_SESSION[post_only_once]); // remove the session after insert
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
We can pick a string from MySQL database with various style.
Example, the value from database is NCABZ-2007
And we want only view ABZ
Here is the CODE.
PHP CODE:$data = "NCABZ-2007";
$new_data = substr($data, 2 , 3);
Explain:
2 = number of data from the left (N=0, C=1, A=2, B=3, etc.)
3 = how much char we want to display
Shorting or cutting the text string from long char into new max lenght.
Here is the code.
PHP CODE
function short_string ($var, $len){
if (strlen ($var) < $len) {
return $var;
}
if (preg_match ("/(.{1,$len})\s/", $var, $match)) {
return $match [1] . "..";
} else {
return substr ($var, 0, $len) . "..";
}
}
short_string ("Very very long text is here blablabla", 14);
Very very long..
Here is the save way from RSS Attack SQL Injection.
Get all variable $_POST or $_GET or $_REQUEST or $_SESSION convert into mysql_real_escape string filter, you do not need one by one for all type variable.
here is code.
PHP CODE
$_POST = array_map('mysql_real_escape_string', $_POST);
$_SESSION = array_map('mysql_real_escape_string', $_SESSION);
$_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);
function mysql_real_unescape_string($string){
$string=trim($string);
$string=str_replace("\\","",str_replace("\$","",$string));
return $string;
}
Here is a php script snippet to convert string text to hex decimal code.
PHP CODE
function text2hex($string) {
$hex = '';
$len =
strlen($string) ;
for ($i = 0; $i < $len; $i++) {
$hex .=
str_pad(dechex(ord($string[$i])), 2, 0, STR_PAD_LEFT);
}
return $hex;
}
The best Filemanagement system PHP what i choose is QuiXplorer.
Here is the detail from contributor:
QuiXplorer is a multi-user, web-based file-manager.
It allows you to manage and/or share files over the internet, or an intranet.
The latest version provides the following functionality:
Source: http://quixplorer.sourceforge.net
The Best WYSIWYG now for me is TinyMCPUK.
Reason:
1. Small file size
2. Complete Editor
3. Image Manager and Image Editor
Here is the detail information from the contributor:
TinyMCPUK brings you the powerful TinyMCE plus the MCPUK file manager and ImageManager strictly integrated together.
TinyFCK package contains:
TinyKCPUK is only available for PHP.
TinyMCPUK 0.1 is updated with TinyMCE 2.0.6.1.
This is simple ready to use.
Image Resize PHP use GD and create seperate file thumb.
And insert into database with id filename, like: 1.jpg or 2.gif, and so on.
Btw, take a look at the comment, it is clear enaugh to understand.
Link: http://www.nusansifor.com/f/showthread.php?t=107
News letter script with PHP and simple text flat file txt.
Very simple newletter script free that i choose is this link: Newsletter Script
The best Unlimited sub categories, I choose this one by Shadi Ali (Jan/15/2006).
The coding is simple, easy to understand and ready to use.
Enjoy...
This script use: PHP and MySQL database.
URL: http://www.phpclasses.org/browse/package/2742.html
How to run the php file from cron job via cpanel?
Here it is:
1. login to your cpanel
2. click cron icon
3. click standar
4. enter your email address for reporting if the cron is failed
5. choose the time what you want
6. enter the command, it depends on your server hosting.
the command should be like this:
curl -s -o /dev/null http://yourdomain.com/your_script.php
if curl is disable form your hosting service, you can use another way, with this:
lynx -dump http://yourdomain.com/your_script.php > /dev /null
if curl and lynx is disable form your hosting service, you can use another way, with this:
/usr/bin/wget -O - /home/your_username/public_html/script.php
or
GET http://yourdomain.com/your_script.php > /dev /null
if curl, lynx and wget is disable form your hosting service, you can use another way, with this:
in the your_script.php file put this at the top the first line before anything:
!#/usr/bin/php
and use this cron command
php -f /home/your_username/public_html/your_script.php
note:
file your_script.php should chmod 755
and the /home/your_username/ is your path on server.
if you have still problem, like " No input file specified. ", please try this:
links http://yourdomain.com/your_script.php
7. save it
done...
if you have error, pls let me know, welcome to leave comment here..
Simple CAPTCHA, easy and ready to use.
Very easy to use simply add the class, and edit setting:$page = $_REQUEST["page"];
$alamat_pag = "http://elkaff.com/?m=Alumni"; // Full adress your PHP script
$adjacents = 3; // do not change if you do not know
$tabel="sample_tabel"; // table database form MySQL
$where=""; // where condition, optional
$order="ORDER BY `date` DESC, `name`"; // order condition, optional
$limit = 10; // set limit per page
include "pagination.php"; // include the class
$no=$start+1; // the number, if you want it to diplay, optional
while($ro = mysql_fetch_array($portfolio)) {
echo $no." ";
echo $ro[nama]."
";
}
echo "Total: $total_pages
";
echo $pagination;
The code is on: http://www.nusansifor.com/f/showthread.php?t=101
Well, this is my choise for simple uploading system:
http://www.chronosight.net/view/2006/04/
465-asynchronous-file-upload-with-php-javascript-iframe.html
take a look...
