Accessing Mysql From Javascript - Javascript to communicate with database
mrdee
Dec 3 2007, 01:47 PM
I found a nice program which allows you to put quizzes on your web site.
You can design your own questions, set the layout of your page, and there is also a possibility of having the results emailed to you. It further offers a facility to store the results and all that, all you have to do is put a link in the program, telling it which page takes care of that. However, when I look at the HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also uses variable names, but as I don't know any Java, I was wondering if those variables are exchangeable with PHP, in order to let it store the name of the quizzer and his/her results in a MySQL database, or whether Javascript can address the issue directly.
If this question is not clear enough or if people require more information in order to answer the question, I can always post the HTML code of the page here.
Java and javascript are two different programming languages. javascript is a client-side scripting language and Java is a full programming language capable of much more. Please confirm which one you are discussing.
javascript is used in AJAX to connect to databases and provide interactive web pages. I am just about to learn some Ajax, so I can't provide any more info than this.
function storetry(question, answer){ yourtry[question] = answer; }
function getscore(){ var y; thisscore = 0; setCookie('save', 'false', 365); for (y=1;y<=count;y++) { if (yourtry[y] =="") { alert("Please answer ALL questions"); return(false); } else if (yourtry[y] == ans[y]) thisscore++; } alert("Your Score is: " + Math.round(thisscore/count*100)+"%"); document.quizform.score.value = Math.round(thisscore/count*100)+"%"; document.quizform.name.value = username; document.quizform.email.value = email; document.quizform.lapsed.value = lapsedtimestr; if (thisscore<count)showerrors(); return(true); }
function showerrors(){ var h; var v =145+((count-thisscore)*20); h = "top=0,left=0,width=180,"; h = h + "height=" + v; h = h + ",scrollbars=1"; var i; var newwin; newwin = window.open("", "", h); newwin.document.write("<FONT size=4><B>Your Error(s)...</B><BR><BR>"); for(i = 1; i<= count;i++){ if (yourtry[i] != ans[i]){ newwin.document.write("\nQuestion: " + i); newwin.document.write("<BR>"); } } newwin.document.write("<BR><B>Have another try...</B><BR><BR></FONT>"); newwin.document.write('<BUTTON onclick="window.close()">Close</BUTTON>'); }
function refresh(){ document.location.reload(); document.quizform.reset(); }
function getCookie(NameOfCookie) { if (document.cookie.length > 0) { begin = document.cookie.indexOf(NameOfCookie+"="); if (begin != -1) { begin += NameOfCookie.length+1; end = document.cookie.indexOf(";", begin); if (end == -1) end = document.cookie.length; return unescape(document.cookie.substring(begin, end)); } } return null; }
function savequiz(){ setCookie('quizuser',document.quizform.name.value,365); setCookie('QuizID',document.quizform.ID.value,365); setCookie('save', 'true', 365); for (x=1; x<=count;x++) setCookie('q'+x, yourtry[x], 365); }
function setCookie(NameOfCookie, value, expiredays){ var ExpireDate = new Date (); ExpireDate.setTime(ExpireDate.getTime() + (expiredays * 24 * 3600 * 1000)); document.cookie = NameOfCookie + "=" + escape(value) + ((expiredays == null) ? "" : "; expires=" + ExpireDate.toGMTString()); }
function docookies(){ var con; username=getCookie('username'); email=getCookie('email'); if (username==null) { alert('Please log in'); window.location = "http://www.vlaanderen-flanders.org.uk"; } else { document.quizform.name.value = username; if ((getCookie('QuizID') == document.quizform.ID.value) && (getCookie('save')== 'true') && (getCookie('quizuser') == document.quizform.name.value)) { con = confirm('Saved quiz found. OK to continue, Cancel to restart.'); if (con) getsave(); } } }
function getsave() { var c; var found = false; var y = 0; var ch = 0; for(x=1; x<=count;x++) { found = false; c = getCookie('q'+x); yourtry[x] = c; while(found ==false){ if ((document.quizform.elements[y].value == c) && (document.quizform.elements[y].type == "radio")) { document.quizform.elements[y].checked = true; found = true; } y=y+1; ch=ch+1; } y = y + choice-ch; ch=0; } }
sorry i did not read your javascript code. I usually don't read long lines of code until I'm fully awake, bored or really have to. But from what you said you want to store variables from javascript to mysql database? well only way to do that is pass javascript variables to PHP. Thats the quick answer.
method 1. post javascript variables using 'get' or 'post' and grabs those in PHP then do mysql queries.
method 2. post javascript variables using ajax (post or get) and do the same thing in PHP and Mysql.
method 1 is more simpler if you are not familiar with ajax just yet.
He's not asking how to do it, from his question, I think he is just wondering if that code IS posting to sql. I do not see any ajax in that code. All of the values are being stored in cookies not sql. If you want to modify that sonesay has some great options for you.
Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL.
I know my question may not be clear because I lack in terminology but pliz try and help. What I want
to do is for axample have a database of my clients with the following fields for every client:
fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want
to have the things like the photos in the same field but they have to be unique so that my php code
can deal with them individually llike they are coming from different fields.....
I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
field in your table gets sort of 'refreshed and updated' so you have a clearer view....
Hi Guys, I am trying to run multiple javascript files on my site to achieve two different
functions. There seems to be a conflict, depending on the order that i run the files it will cause
one function to work and the not to. The conflicts I get are from Lightwindow and JScrollPane
. I have read that this can be an onload problem. Has anyone had this same problem? I noticed it
also happens when i mix JscrollPane and Lightbox v2. Any help or suggestions would be appreciated,
Cheers.....
I use a nice program (which I helped to beta test) called ' Simfatic Forms ' to generate
forms on web pages. The only problem is that it does not (yet) support MySQL databases, it saves the
form data as a .CSV file. Now I was wondering if you can do the same with a .CSV file as you do
with a MySQL databse, ie. displaying the data in that file on a web page which adjusts automatically
as data are added to the file. To clarify: eg. if I make a form to sign a petition online, the data
are saved to a .CSV file every time someone fills in the form, is it now possibl....
Hi, I am creating a website in php and using a mysql database to store the data. I want to store
time data in the database. My question is what is the best datatype I should use and how do I read
the time from the database and format(display) it using php ?....
So i was looking for a feedback form in javascript and i couldn't find one so ive made one for
you guys here we go! So this feedback form will ask for name, emails address and their comments
First of all add this code in between the and tags CODE <script
name="JavaScript"> <!-- function SendEmail() { var toaddy =
'name@domain.com'; var subject = 'JS Form Submission'; var mailer =
'mailto:' + toaddy + '?subject=' + subject + '&body=' +
'Name%20is\....
In my MySQL table I would like to use one text field which can contain lots of text. What I want to
use it for is for student records, and I want to be able to add to it without destroying what is
already there. I want the field to contain something like: ****03/11/2007**** Chopin prelude No 9:
small problem bars 12-15. Advice given on how to practice. ****10/11/2007**** Problem in Prelude
overcome, piece successfully completed. New piece set: Beethoven Sonata No 1, movement 1. etc. This
is of course just an example, but that is how I want to set up my student records....
If I wanted to use an ID field which automatically increments when data are addad, but displays the
ID as a 5 figure number, which data type would I have to use? I would want a type that assigns a
number to a record in the format "00001", "00002", etc. However, when I use "int" as datatype, it
only displays th field contents as "1", "2" etc. So, which data type could do the job for me? i do
not need a decimal point or anything, just an id that displays in 5 figures, including the leading
zeros. Thanks in advance.....
Hi, on my local machine (with Apache 2.0, PHP 5.2.4 and MySQL 5.0) I come across weird things. I
have successfully made a table, but when I try to enter data into it it just will not accept the
empty string for the first field (id). This was the creation line: QUOTE $query="CREATE
TABLE members (id int(20) auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone
varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT
NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"; This has....
I know I might sound a bit novice, but I'd like to know how to make a register and login
database. I'm making a serious website for the very first time and I can't find on internet
how to make one (don't even know how it is named). I would really appreciate me if someone could
link me to a tutorial or give me the explanation, also the program to use (I think Microsoft Access
is good?)....
Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
account for each script is there any way like mergning one user name and password would work for 3
section. if you don't get my question please tell me i will try to explain more in detail
thank you for your time and help ....
I got bored and lazy working on the things that I should do... so I end up creating this tree menu
for anyone to use if they find it interesting. Well the idea is to create a tree menu in a webage.
Instead of those linear menu it would be better to add more dynamic to your webpage with a tree
menu. Others use image rollovers. As expecte the tree menu should behave like the one in Windows
Explorer. When you click a node depending on its state it will pull down or pull up its chlid nodes.
I have achieved by exploiting one style sheet property, display . Basically this s....
Hello All. I'm looking for some advise or assistance with getting a web page/access page
running so that i can have the page online and collect the data live into my database for Project
Management... Currently I'm developing a database using M$ Access, and need to have staff
data enter sales information directly into a web form that can be linked to a database? I've
looked at using a M$ Front page web form with data collected into a .CSV text file and
extracting the data but i need to be able to let the staff review and update the data for eac....
How do you combine multiple mysql databases into one database? I was thinking thta soem servers
restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
would use one database for that. For every table of dynamic information, I use one database. Can I
streamline what I am doing and combine all of my databases into one? I could make multipple tables
in the same database. Would that work? thanks....
Hi if someone could get back to me as fast as they can that would be great! i got a couple of
questions what do you use my sql for what does that have to do with forums? and secondally can
someone give me the php code for the forum thanks /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" />....
I just finished reading a php book, and figured out some interesting things, and wanted to share
them with the Trap17 community. I know lot of you make websites so this could help out. Enjoy
QUOTE Introduction So, you've spent the best part of a year creating your PHP/MySQL driven
web site. You've got a fair amount of decent, flexible content, and you're buddies with a
couple of other webmasters, so they've given you a free banner ad on their site in exchange for
one on yours. Promoting your site can be even harder than developing it. I've foun....
Ok soo....I have different authentification required areas of a website I'm currently working
on, and I'd like to find a way to link to one pass. protected area from another, after
someone's already logged in...but each time the Popup window comes up asking for the username
and password...anyone know a way around this other than programming a php a java password protection
script? I'd really prefer to use the server's method, as it's much more concrete.
I've seen some information about a syntax along the lines of: http://username:passwor....
Hey...I have a java code of RSS feeds.When i put it in my website , on front page,and when i
preview,there is blank place (where news should be) and there is a yellow bar on internet
explorer..there is a message.. "To Help protect your security,Internet explorer has resticted this
file from showing active content that could access your computer.Click here for more options" And
when i click to that bar, there is option "ALOW BLOCKED CONTENT" THen it shows those news. I am
very upset.Because i dont want that bar.Can you please help me by telling the way , that there comes....
I'm not a professional web developer but I've learned a lot since I used Macromedia
Dreamweaver. The latest version 8 supports PHP 5. If you select PHP as your working language, you
can use this software to automatically add dynamic content to your website with MySQL as a
requisite. If you have a MySQL database containing records like a songs information database, then
you might probably not be able to add a good search page to your website which will search records
in the database. I faced the same problem, but now I'm able to create one sophisticated datab....
hi.. i'm new in php and mysql... here is my problem.... $sql = "SELECT COUNT(*) FROM
messages WHERE _parent={$row }"; after sending the query above i dont know how to fetch the
actual rows counted.. i tried using the mysql_fetch_array() and mysql_fetch_row() function but it
didnt work... actually the only function i know that fetches results from sql queries is
mysql_fetch_array()... so what function or code i need to have the result from the query which uses
COUNT?....
Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....
helo! hou do you? i need somebody post the data for acces my mysql database from my client.
thanks a lot! also i need the alter code for add a foreign key to a column on a table, thanks a
lot /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' /> Moved to the
appropriate section. Don't put questions in the tutorial section please. ....
HI, If anybody worked with dreamweaver, and succesfully used JS codes and CSS in their website,
please reply and tell me how to, cause when I try too put Javascripts it won't work....I also
tried to put an textarea with scrollbars in a table...put in design view the content won't stay
in the widths and heights I typt in...can someone help? thanks ....
Hey, anybody know a DHTML menu that reads info from a database? for people who don't know, just
like windows' "start menu" with the popup menus I want to mod it so that in phpnuke I can edit
it admin panel end. I would like it to be vertical. Do not use note tags because they are only for
admins and moderators. ....
If you have set a root password, but forgot what it was, you can set a new password with the
following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld
server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory:
shell> kill `cat /mysql-data-directory/hostname.pid` You must be either the Unix root user or the
same user mysqld runs as to do this. 2. Restart mysqld with the --skip-grant-tables option. 3. Set
a new password with the mysqladmin password command: shell> mysqladmin -u root password &....
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE
forum, Create your own topics, Ask Questions, track topics, setup
subscriptions & notifications and Get a Free Website w/ Email and FTP.