Debian Programming :: HTML5 To Access MYSQL Database
Jul 24, 2013
I have a MySQL database running on my local server, which I currently access via laptop, desktop using HTML/PHP.I want to re-write in HTML5, I have gone through a couple of HTML5 tutorials but cannot figure out the database interface. The best match I can find is Server-Sent Events, is this the best way forward? What about writing to the database? I have found several suggestions using Web SQL database but I don't think this is suitable as my database is also accessed from Python code on the server.
I'm trying to migrate my company server to linux, but i have a program that is designed in access what is the best way to move access tables to a mysql database so that i can program it in PHP?
I am trying to re-write my local web pages in HTML5. My original pages used an include file so that I had a consistent set of links on the top of each page. I used - require("link_list.php");
But this does not seem to be possible in HTML5. I am guessing that there is a way to do this, searching the web suggests object or embed, but these create a new page within my original page, which is not what I want.
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
I'm getting duplicate entries in mysql database when submitting a new item from a form. I initially loaded the database via IMPORT function in phpMyAdmin. This is my input form:
I want to insert values into a MySql database. The following line works fine:1
Code: mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')"); but if the data to be inserted is from a string... like.... Code: string NewTitle = "Monaco"; string NumofShows = "2";
How do i edit my sql statements so variables can be inserted into the Values ( ) , and it will be able to read the variables and then store it into the database.
I have set up a MySQL database which has only three fields for user-name, password and index number. But there is a LOT of data (thousands of columns) which would take too long to enter manually. I'm sure MySQL must have a file format whereby a single large file containing different data types can be successfully automatically imported and the various data elements distributed to their intended fields. Does anyone know which characters MySQL uses as field seperators for this formatting of data, or is there a program already written which can take raw data and organize it into a SQL compatible file?
Also, the CSV file is updates every few hours and I need to load any new data from the file to the database without creating duplicates of data that has already been loaded to the database.
I would like to make a script which reads a POP3 mailbox on another server and saves the items in the mailbox to a MySQL database. Is this possible? I have to make this script to create monitoringen scripts which has to use the messages in the mailbox.
how to trigger a script when an email is received to update my mySQL database. I do not want to physically send the message to the script, I just want the script to execute and to under execute under a specific mail account.
I thought of setting up a cron job at first, but decided going down that approach would be a huge waste of resources. What method would you recommend?
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
I have an access database and I would like to build a website on the slackware 12.2 server running apache 2.11.14 to let users query data from the MS Access database. I am thinking that I could just do it in jscript and make a jdbc connection and that should be good. What do you guys think.
I am trying to connect to my mysql database using php but I am getting the error "Fatal error: Call to undefined function mysql_connect()".
I checked phpinfo() and there is no reference to MySQL. I believe this means that my install of PHP doesn't support MySQL. Do I need to uninstall and reinstall with a version of PHP with MySQL support? If so how should I do this and how do I get a version of PHP that supports MySQL?
I can play a sound on my local machine using the following code, but when I upload to a server the same code it does not play. I cannot work out why, the link below gives the code. The multi channel code is here:
I pretty much code by hand, but I like Quanta Plus and Kate for scripts HTML and simple programming tasks.Quanta (and other editors nvu, bluefish etc) are geared for html 3 and 4 - help files, tag libraries, templates etc. how far Quanta and other IDEs are into HTML5 support?
I've just installed mysql-server (apt-get install mysql-server) in my debian vps, it ask for password of which i had provided. However after the install finishes, i run the command "mysql -u root -p", i entered my password but says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES".
I am using pepperflash and the youtube HTML5 player on Debian Sid, on an amd64 machine. I am having a problem where the video will just black out every so often, like every minute or two, the audio still works and I need to either go forward or backward in the video to get the image back. I have noticed it on youtube videos which I suppose uses the HTML5 player not pepperflash.
YouTube now automatically serves html5 content if it detects you are using firefox version 40 or above. Unfortunately as a result, all youtube videos are now served to me at 360p resolution, and there is no way to change that on the youtube web page.
Before upgrading firefox, I could watch hd videos using flash. The ability to switch to html5 was also available on [URL] .... But with the later version of firefox, the option to switch back to using flash is no longer there on that page.
When I could view both flash and html5 videos (with the older firefox), I found that html5 played back very poorly. flash, despite being a known resource hog, actually played back better (with no h/w acceleration of flash in linux, I resigned myself to expect to use faster PCs to run flash hd at full screen). Which is a great pity, as we all know flash is disappearing, but it appears I now have an even bigger issue with html5. Where's the hd video?
So how can I get a better html5 experience? My machine is an i3 with GTS250 nVidia running Stretch.
The problem of only getting 360p resolution is probably a bug in firefox. Once I can get hd, I am then uncertain if firefox could handle it.
The advice of setting 'media.mediasource.enabled' in about:config to true to get higher resolutions did not work for me.
When I do that, the [URL] .... says I have:
HTMLVideoElement, WebM VP8 and Media source Extensions support, and H.264, MSE & H.264 and MSE & WebM VP9 unsupported.
I have hardware acceleration enabled in firefox, and have the OpenH264 Video Codec (Cisco) plugin installed.
Some more info here: [URL] ....
I could switch back to using flash by using a user-agent switcher to fool youtube I have an older firefox, but that is a poor solution.
I am using chrome Version 50.0.2661.75 (64-bit) running on Debian (Gnome).
I am having the following problem, since yesterday every time I want to play a video (for ex [URL]watch?v=UF8uR6Z6KLc) The music, logo in the video and functions work but the video doesn't play. I reinstalled Chrome, clean all the data, disable all the plugins, I tried as incognito and several other options and it doesn't work, before yesterday it was working (yesterday I updated all Debians packages).