是否可以使用Ajax从MySql数据库中获取最后一行?
这就是我的PHP:
<?php
include('../../dbconn.php');
//--------------------------------------------------------------------------
// Example php script for fetching data from mysql database
//--------------------------------------------------------------------------
$databaseName = "test";
$tableName = "generalTransactions";
//--------------------------------------------------------------------------
// 1) Connect to mysql database
//--------------------------------------------------------------------------
$con = mysql_connect($gaSql['server'],$gaSql['user'],$gaSql['password']);
$dbs = mysql_select_db($databaseName, $con);
//--------------------------------------------------------------------------
// 2) Query database for data
//--------------------------------------------------------------------------
$result = mysql_query("SELECT * FROM $tableName"); //query
$array = mysql_fetch_row($result); //fetch result
//--------------------------------------------------------------------------
// 3) echo result as json
//--------------------------------------------------------------------------
echo json_encode($array);
?>这是Ajax:
$(function ()
{
//-----------------------------------------------------------------------
// 2) Send a http request with AJAX http://api.jquery.com/jQuery.ajax/
//-----------------------------------------------------------------------
$.ajax({
url: 'general/transactions/add-journal.php', //the script to call to get data
data: '', //you can insert url argumnets here to pass to api.php
//for example "id=5&parent=6"
dataType: 'json', //data format
success: function(data) //on recieve of reply
{
var id = data[0];
var prefix = data[1]; //get prefix
var journalNum = data[2]; //get journal number
//--------------------------------------------------------------------
// 3) Update html content
//--------------------------------------------------------------------
//recommend reading up on jquery selectors they are awesome
// http://api.jquery.com/category/selectors/
if(!journalNum){
$('#generalJournalNumber').val('GJ00000001');
}
id++;
$('#generalJournalNumber').val(prefix+'0000000'+id);
}
});
}); 基本上,我想得到最后一个id和自动增量,上面只增加了数据库中的第一行。
如有任何帮助或建议,将不胜感激!
发布于 2013-07-29 12:17:11
只需在主键上降序添加一个顺序,并将其限制为第一个结果:
SELECT * FROM TableName ORDER BY TableId DESC LIMIT 1发布于 2013-07-29 12:20:08
试着按订单订购。您将得到表的最后一行。
语法
SELECT *
FROM table_name
ORDER BY column1, column2 例:-
SELECT * FROM `Tbl_name` ORDER BY 'id' DESC LIMIT 1发布于 2013-07-29 12:22:49
使用ajax并保持PHP的相同版本:
var id = data[data.length-1];但是,我更喜欢更改ajax函数,以便它能够理解您要做的事情,并通过PHP返回最后一个id。如果您只需要最后一个id,但您正在重新分配数据库中的所有数据,那就有点过分了。
https://stackoverflow.com/questions/17923728
复制相似问题