phpÊý×é×Ö·ûÁ¬½Ó³É×Ö·û´®µÄÎÊÌâ
ÇëÎÊÏÂÃæµÄ³ÌÐòÄÇÀï´íÁËÄØ£¿ÊǹØÓÚÊý×é×Ö·ûÁ¬½Ó³É×Ö·û´®µÄÎÊÌ⡣лл£¡
<?php session_start();include("conn/conn.php");
if($submit=="Ìá½»"){
$array1=array();//¶¨ÒåÊý×é~~~ÓÃarray()Õâ¸öº¯Êý
$array2=array();
$i=0;
while(list($name,$value)=each($_POST)){
if($value!="Ìá½»"){
$array1[$i]=$nama;
$array2[$i]=$value;
}
$i++;
}
$str=implode(",",$array1);//½«Êý×é±ä³É×Ö·û´®
$str1=implode(",",$array2);
$str1="".$str1."";
$query=MySQL_query("insert into tb_user($str)values($str1)",$id);
if($query==true){
echo " <script>alert('Êý¾ÝÌí¼Ó³É¹¦');history.back(); </script>";
}
else{
echo " <script>alert('Êý¾ÝÌí¼Óʧ°Ü');history.back(); </script>";
}
}
?>
implodeÖ»¶ÔһάÊý×éÓÐÓÃ,ÄãµÄarray1ºÍarray2ÊǶàά¿Ï¶¨Ö´Ðв»ÁËSQL;
½¨ÒéÔÚ×öµ÷ÊÔµÄʱºò°ÑÄãµÄSQLÓï¾äecho³öÀ´,ÕâÑù²ÅÈÝÒײéÕÒÎÊÌâËùÔÚ
explodeÊǽ«×Ö·û´®·Ö¸î³ÉÊý×飡
echo $str; //Õâ¸öÒ»°ã²»»á´í
echo $str1; // ÎÊÌ⽫³öÔÚÕâÀï
°´¹æÔò£¬×Ö·ûÀàÐ͵ÄÖµÒªÓõ¥ÒýºÅÀ¨Æð£¬¶øÄãûÓÐ
¼´±ãÊý¾ÝÀàÐͶ¼ÊÇÊýÖµÐ͵ģ¬Èç¹ûij¸ö¿Ø¼þֵΪ¿Õ½«³öÏÖÀàËÆ¡°12,,3¡±,ÕâÒ²ÊÇÎ¥¹æµÄ
$str1 = "'" . implode("','", $array2) ."'";
Ïà¹ØÎÊ´ð£º
±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid']
ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid']
ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ
function showdiv()
{
var kk=<?= $fID ? ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÕÐÆ¸Ö°Î»£ºÉè¼ÆÈËÔ±
ѧ Àú£º²»ÏÞ
Ö÷Òª¹¤×÷£ºÍøÒ³Éè¼Æ£¬Æ½ÃæÉè¼ÆµÈÉè¼ÆÀ๤×÷¡£
×îµÍÒªÇó£ºÖÁÉÙÓо«Í¨Ò»ÃÅÊìÁ·µÄÉè¼Æ¹¤¾ß£¬È磺PS¡¢AI¡¢FWµÈ¡£
н Ë®£ºÃæÒ飬ÊÔ¹¤×÷ÄÜÁ¦¶ø¶¨¡£
ÓÅÏÈ¿¼ÂÇÌõ¼þ£º
1. ´´Òâ˼Π......
ÈçÌ⣬ÓÐûÓÐÕâÑùµÄphp´úÂë¡£ÎÒÏÖÔÚÏ뽫excelµÄÄÚÈݲåÈëmysqlÊý¾Ý¿â£¬Ï£Íû¿ÉÒÔ½«excelת³Éxml,È»ºó½âÎöxml²åÈëÊý¾Ý¿âÖС£Èç¹ûÓÐÕâÑùµÄ´úÂ룬ÉõÖÁÊÇÓÐÃûµÄ´úÂ룬һ¶¨Òª¸æËßÎÒ°¡¡£
ÏȶÁ excel => È»ºóÉú³É xml = ......