javascript - ajax post to php not actually writing to the mysql table -

- 

$(document).ready(function() {     $('#save').click(function() {          var rows = [];          (i = 1 ; < document.getelementbyid("schedule").rows.length ; i++) {             var name;             var tuesday;             var wednesday;             var thursday;             var friday;             var saturday;             var sunday;              name = document.getelementbyid("schedule").rows[i].cells[0].firstchild.value;             tuesday = document.getelementbyid("schedule").rows[i].cells[1].firstchild.value;             wednesday = document.getelementbyid("schedule").rows[i].cells[2].firstchild.value;             thursday = document.getelementbyid("schedule").rows[i].cells[3].firstchild.value;             friday = document.getelementbyid("schedule").rows[i].cells[4].firstchild.value;             saturday = document.getelementbyid("schedule").rows[i].cells[5].firstchild.value;             sunday = document.getelementbyid("schedule").rows[i].cells[6].firstchild.value;             monday = document.getelementbyid("schedule").rows[i].cells[7].firstchild.value;              rows[i-1] = "name=" + name + "&tuesday=" + tuesday + "&wednesday=" + wednesday + "&thursday=" + thursday + "&friday=" + friday + "&saturday=" + saturday + "&sunday=" + sunday + "&monday=" + monday;         }          (i = 0 ; < rows.length ; i++) {             $.ajax({             type: "post",             url: "save-schedule.php",             data: rows[i],             success: function () {                 alert("post successful");             }             });         }     }); });

the javascript array working correctly , showing correct format , ajax success function executing. shows alert "post successful" after checking mysql table empty.

<?php $servername = "localhost"; $username = ""; $password = "";  $conn = new mysqli($servername, $username, $password);  if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }  $conn->select_db("little_caesar");  $name=$_post["name"]; $tuesday=$_post["tuesday"]; $wednesday=$_post["wednesday"]; $thursday=$_post["thursday"]; $friday=$_post["friday"]; $saturday=$_post["saturday"]; $sunday=$_post["sunday"]; $monday=$_post["monday"];  $conn->query("insert schedule (name,tuesday,wednesday,thursday,friday,saturday,sunday,monday) values('$name','$tuesday','$wednesday','$thursday','$friday','$saturday','$sunday','$monday')");  $conn->close(); ?>

this save-schedule.php great! in advance!

remove '&' symbol ajax data change instead of , symbol like

rows[i-1] = "{name=" + name + ",tuesday=" + tuesday + ",wednesday=" + wednesday + ",thursday=" + thursday + ",friday=" + friday + ",saturday=" + saturday + ",sunday=" + sunday + ",monday=" + monday+"}";

Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more