Will this be the only way to do it in the morning from now on - jQuery, in the morning - jquery_PHP tutorial

以后上午就只能这样了么-jQuery，上午么-jquery

　　hi

昨天睡得不错

为什么早上还是看不进论文，宁愿做这个，也不愿认真看论文。感觉上还是下午看论文感觉要好的多。不过最近有三十多篇要看哇。。。管球。。。

1、jQuery

-----jQuery常用插件-----

----表单插件——form

通过表单form插件，调用ajaxForm()方法，实现ajax方式向服务器提交表单数据，并通过方法中的options对象获取服务器返回数据，调用格式如下：

<strong>$(form). ajaxForm ({options})</strong>

其中form参数表示表单元素名称；options是一个配置对象，用于在发送ajax请求过程，设置发送时的数据和参数。

个人信息页

用户名：



昵称：

----图片灯箱插件——lightBox

该插件可以用圆角的方式展示选择中的图片，使用按钮查看上下张图片，在加载图片时自带进度条，还能以自动播放的方式浏览图片，调用格式如下：

<strong>$(linkimage).lightBox({options})</strong>

其中linkimage参数为包含图片的元素名称，options为插件方法的配置对象。

我的相册

• 
  
  


• 
  
  


• 
  
  

----图片放大镜插件——jqzoom

在调用jqzoom图片放大镜插件时，需要准备一大一小两张一样的图片，在页面中显示小图片，当鼠标在小图片中移动时，调用该插件的jqzoom()方法，显示与小图片相同的大图片区域，从而实现放大镜的效果，调用格式如下：

<strong>$(linkimage).jqzoom({options})</strong>

其中linkimage参数为包含图片的元素名称，options为插件方法的配置对象。

图片放大镜

----cookie插件——cookie

使用cookie插件后，可以很方便地通过cookie对象保存、读取、删除用户的信息，还能通过cookie插件保存用户的浏览记录，它的调用格式为：

保存：<strong>$.cookie(key</strong><strong>，</strong><strong>value)</strong>；读取：<strong>$.cookie(key)</strong>，删除：<strong>$.cookie(key</strong><strong>，</strong><strong>null)</strong>

其中参数key为保存cookie对象的名称，value为名称对应的cookie值。

cookie插件

邮箱：



是否保存邮箱

----搜索插件——autocomplete

搜索插件的功能是通过插件的autocomplete()方法与文本框相绑定，当文本框输入字符时，绑定后的插件将返回与字符相近的字符串提示选择，调用格式如下：

<strong>$(textbox).autocomplete(urlData,[options]);</strong>

其中，textbox参数为文本框元素名称，urlData为插件返回的相近字符串数据，可选项参数options为调用插件方法时的配置对象。

搜索插件

用户名

----右键菜单插件——contextmenu

右键菜单插件可以绑定页面中的任意元素，绑定后，选中元素，点击右键，便通过该插件弹出一个快捷菜单，点击菜单各项名称执行相应操作，调用代码如下：

<strong>$(selector).contextMenu(menuId,{options});</strong>

Selector参数为绑定插件的元素，meunId为快捷菜单元素，options为配置对象。

点击右键

• 保存


• 退出

----自定义对象级插件——lifocuscolor插件

自定义的lifocuscolor插件可以在

元素中，鼠标在表项
• 元素移动时，自定义其获取焦点时的背景色，即定义
• 元素选中时的背景色，调用格式为：

  <strong>$(Id).focusColor(color)</strong>

  其中，参数Id表示

  元素的Id号，color表示
  • 元素选中时的背景色。
    
    
    
    

    
    对象级别的插件
    

    
    

    
    

    
    
    • 橘子水果
    
    
    • 芹菜蔬菜
    
    
    • 香蕉水果
    
    

    
    

    
    
    
    
    
    

    ----自定义类级别插件—— twoaddresult

    通过调用自定义插件twoaddresult中的不同方法，可以实现对两个数值进行相加和相减的运算，导入插件后，调用格式分别为：

    <strong>$.addNum(p1,p2) </strong>和<strong> $.subNum(p1,p2)</strong>

    上述调用格式分别为计算两数值相加和相减的结果，p1和p2为任意数值。

    
    
    
    

    
    自定义类级别插件
    
    
    
    

    
    

    
    两数相减：
    
    -
    
    =
    
    

    
    
    
    
    
    

    2. MySQL&PHP

    -----php built-in MySQL function (1)-----

    ----Connect to database

    mysql_connect

    mysql_connect('localhost','root','');

    That is to say, this function has 3 parameters, database name or IP address, username, password

    Note that it is generally believed that mysql_connect will no longer be supported in future versions (it seems that versions after php5.5) can be replaced by mysqi_connect

    if(mysqli_connect('localhost','root','')){
    echo "Connection successful";

    }else{
    echo "shit";
    }

    The test code is as above

    After the connection is successful, the mysql connection identifier will be returned (the use will be mentioned below); if it fails, false will be returned

    ---Database extension

    A database in PHP may have one or more extensions, including official ones and those provided by third parties. Commonly used extensions for Mysql include the native mysql library, you can also use the enhanced mysqli extension, and you can also use PDO for connection and operation.

    Different extensions provide basically similar operation methods. The difference is that they may have some new features and the operation performance may be different.

    Mysql extension method for database connection:

    $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password');

    mysqli extension:

    $link = mysqli_connect('mysql_host', 'mysql_user', 'mysql_password');

    PDO extension

    $dsn = 'mysql:dbname=testdb;host=127.0.0.1';
    $user = 'dbuser';
    $password = 'dbpass';
    $dbh = new PDO($dsn, $user, $password);

    ----Close database connection

    mysql_close

    mysql_close($con); Close the previous connection, where $con is the identifier returned after mysql_connect() succeeds

    $con=mysqli_connect('localhost','root','','info');

    ----Select database

    mysql_select_db()

    $con=mysqli_connect('localhost','root','','info');
    if($con){
    echo "Connection successful";
    }else{
    echo "shit";
    }
    //mysql_close($con);
    if(mysqli_select_db($con, 'info')){
    echo "Success ";
    }else{
    echo "shit";
    }

    Since my PHP version is relatively high, mysql basically doesn’t recognize it, so I switched to mysqli. However, the basic usage is similar, but I need to pay attention to the parameters. Generally speaking, the compilation software (I use Zend) has prompts, so don’t worry

    ----Execute SQL statement

    mysqli_query()

    mysqli_query($con, "INSERT test(name) VALUES('Tom')");
    
    

    mysqli requires connection, $con

    ---Execute MySQL query

    After establishing a connection to the database, you can query, using the form of mysql_query plus sql statement to send query instructions to the database.

    $res = mysql_query('select * from user limit 1');

    For query class statements, a resource handle (resource) will be returned, and the data in the query result set can be obtained through this resource.

    $row = mysql_fetch_array($res);
    var_dump($row);

    By default, PHP uses the nearest database connection to execute the query, but if there are multiple connections, you can query from that connection through the parameter command.

    $link1 = mysql_connect('127.0.0.1', 'code1', '');
    $link2 = mysql_connect('127.0.0.1', 'code1', '', true); //开启一个新的连接
    $res = mysql_query('select * from user limit 1', $link1); //从第一个连接中查询数据

    //Connect to the database
    mysql_connect('127.0.0.1', 'code1', '');
    mysql_select_db('code1');
    mysql_query("set names 'utf8'");
    //Perform data query here
    $res = mysql_query("select * from user limit 1");

    $row = mysql_fetch_array($res);

    var_dump($row);

    ---Insert new data into MySQL

    After we understand how to use mysql_query for data query, similarly, inserting data is actually achieved by executing a sql statement, for example:

    $sql = "insert into user(name, age, class) values('李四', 18, '高三一班')";
    mysql_query($sql); //执行插入语句

    Usually data is stored in variables or arrays, so the sql statement needs to be string spliced ​​first.

    $name = '李四';
    $age = 18;
    $class = '高三一班';
    $sql = "insert into user(name, age, class) values('$name', '$age', '$class')";
    mysql_query($sql); //执行插入语句

    In mysql, after executing the insert statement, you can get the auto-incremented primary key id, which can be obtained through PHP's mysql_insert_id function.

    $uid = mysql_insert_id();

    This ID is very useful. It can usually be used to determine whether the insertion is successful, or as an associated ID for other data operations.

    //Connect to the database
    mysql_connect('127.0.0.1', 'code1', '');
    mysql_select_db('code1');
    mysql_query("set names 'utf8'");
    //The known data variables are
    $name = '李思';
    $age = 18;
    $class = 'Class 1, Grade 3';
    //Perform data query here
    $sql="insert into user(name,age,class) value ('$name','$age','$class')";
    mysql_query ($sql);
    $uid=mysql_insert_id();
    print_r($uid);

    I’m going back to watch the Chinese team’s game and will continue tomorrow

    http://www.bkjia.com/PHPjc/1072327.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1072327.htmlTechArticle From now on, will this be the only way in the morning - jQuery, in the morning - jquery hi I slept well yesterday, why do I still watch it in the morning? If I don’t get into the paper, I would rather do this than read the paper seriously. Does it feel up or down...