douza9835 2013-10-21 12:31
浏览 45
已采纳

从ajax获取数据并发送到mysql

I have simple ajax code:

function showMe(data) {
    $("body").append();
    if(data.success == true) {
        $("body").append("<img src="+data.data.link+" height=180 /><br /><a href="+data.data.link+">"+data.data.link+"</a>");

$.ajax ({
    type: "POST",
    url: "sql.php",
    data: "y=+data.data.link+",
});

i need to get '+data.data.link+' value and send to mysql db, but it sends data.data.link and not real link. How to get real value and send to db ? Here is sql.php:

<?php
define('IN_PHPBB', true); 
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : 'forum/'; 
$phpEx = substr(strrchr(__FILE__, '.'), 1); 
include($phpbb_root_path . 'common.' . $phpEx); 
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
include("$phpbb_root_path/includes/functions_user.php");
$user->session_begin();
$auth->acl($user->data);
$user->setup('viewtopic');

include "forum/config.php";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
$db_selected = mysql_select_db("$dbname", $link);

$y = @$_POST['y']; 

$date = date('d.m.y');
$name = $user->data['username'];

mysql_query("INSERT INTO `gallery` (name, createdate, piclink) VALUES('$name', '$date',  '".$y."')");

unlink("gallery/$imagename");
?>

Thanks for any help :)

  • 写回答

2条回答 默认 最新

  • doutang3760 2013-10-21 12:33
    关注

    send data as object (clean and readable) and not string..

    try this

     data: {'y':data.data.link},
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 unity第一人称射击小游戏,有demo,在原脚本的基础上进行修改以达到要求
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥15 cmd cl 0x000007b
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差(基于双目相机)