刘泰宇_新浪博客

<HTML><HEAD><TITLE>浏览图片</TITLE>
<META http-equiv=Content-Type content='text/html; charset=gb2312'>
<META content='MSHTML 6.00.2800.1264' name=GENERATOR>
<link href='../css/css.css' rel='stylesheet' type='text/css'>
<style type='text/css'>

</style></HEAD>
<BODY>
<CENTER>
<table width='460' height='460' border='1' cellpadding='1' cellspacing='1'>
<tr>
<td height='450' align='center'><p><a href='<%{$res[a].userfile_name}%>'><img src='http://guestbook/thumbs/

点击查看原文

阅读|评论|收藏|打印|举报

php向mysql数据库中导入excel记录|| csv文件导入MYSQL(2007-07-30 21:52)

分类：技术

php向mysql数据库中导入excel记录

<?
//连接数据库文件(localhost是主机名,root是用户名,root是用户密码)
$connect=mysql_connect('localhost','root','root') or die('could not connect to database');
//连接数据库(db1)
mysql_select_db('db1',$connect) or die (mysql_error());

$temp=file('test.csv');//连接EXCEL文件,格式为了.csv

for ($i=0;$i<count($temp);$i++)

{

$string=explode(',',$temp[$i]);//通过循环得到EXCEL文件中每行记录的值

//将EXCEL文件中每行记录的值插入到数据库中
$q='insert into agent
(agent_number,main_corp_name,agent_chengnuo_amount_1,agent_chengnuo_amount_2,agent_chengnuo_amount_3,agent_chengnuo_amount_4,main_guoshui_number,main_bank,main_bank_zhanghao,main_address,main_postcode,agent_province_

点击查看原文

阅读|评论|收藏|打印|举报

PHP综合搜索引擎(2007-07-27 16:13)

<html>
<head>
<title>PHP综合搜索引擎</title>
<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>
</head>
<body>
<div align='center'>
<H1><p align='Center'>PHP综合搜索引擎</p></H1>
<form name='form1' method='get' action='PHPsousuo.php' target='_blank'>
    搜索：
    <input name='key' type='text' size='64'>
    <select name='select'>
      <option value='google' selected>Google</option>
      <option value='yahoo'>Yahoo</option>
      <option value='baidu'>Baidu</option>
    </select>
    <input type='submit' value='提交'>
</form>
<p>Cop

点击查看原文

阅读|评论|收藏|打印|举报

PHP+MYSQL 连接数据库(2007-07-25 09:50)

<?php
$dbhost = 'localhost';
$dbuser = 'root'; //你的mysql用户名
$dbpass = ''; //你的mysql密码
$dbname = 'db1'; //你的mysql库名
$connect = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
$sql = 'SELECT * FROM `user` WHERE 1 ';
$Res = MYSQL_query($sql);
if($Res)
{
echo 'ok';
}
else
{
echo 'no';
}

点击查看原文

阅读|评论|收藏|打印|举报

数列显示(2007-07-25 09:41)

<title>显示数列</title>
<script language='javascript'>
function tianjia() //选择单个用户
{
var   sel=document.all.zuoshu;

for(i=0;i<sel.options.length;i++)
{
    if(sel.options[i].selected)
    {
      var text=sel.options[i].text;
      var values=sel.options[i].value;
      if( values.value !='' && text.value !='')
       {
        var   oOption   =   document.createElement('OPTION');//创建OPTION元素
           oOption.text=text;
  &nbs

点击查看原文

阅读|评论|收藏|打印|举报