My app no longer connects to its DB and phpmyadmin says #1129 - Host 'xxx.xx.xx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' mysql_error() prints out the same message. Could this be because of too many connections? What causes this? ...
I've got an iPhone App that is supposed to send POST data to my server to register the device in a MySQL database so we can send notifications etc... to it. It sends it's unique identifier, device name, token, and a few other small things like passwords and usernames as a POST request to our server. The problem is that sometimes the serv...
Seems like MySQL has changed their webpage and I can no longer find any kind of links to any kind of manuals (I'm interested in 5.1). This is making development a lot harder. Does anyone know where the links have gone? Perhaps I'm simply overlooking something? ...
I've ran through several examples over the web, and found that every single time I need something from the DB, I should write the following code: try { // Step 1: Load the JDBC driver. Class.forName("mysql_driver_name"); // Step 2: Establish the connection to the database. String url = "jdbc:string_to_mysql_server"; Connec...
In MySQL: Every one minute I empty the table and fill it with a new data. Now I want that users should not read data during the fill process, before or after is ok. How do I achieve this? Is transaction the way? ...
Maybe it is to much to ask... I want to make a online WYSIWYG HTML / CSS builder where the graphic designer can build a website template without knowing CSS /HTML. For that purpose there should be a GUI to build a website template. That means HTML and CSS are created out of the choices selected in the GUI. http://www.constructyourcss....
I have the following table (points): recno uid uname points ============================ 1 a abc 10 2 b bac 8 3 c cvb 12 4 d aty 13 5 f cyu 9 ------------------------- -------------------------- What I need is to show ...
I have two distinct scenarios. One, where there is a many to many case, you must create a third table. But I'm not familiar with MySQL syntaxis. Two, is this one: How can I declare using SQL code? ...
create table snippet( id int not null auto_increment, primary key(id), idlanguage int not null, foreign key(idlanguage) references language(id), iduser int not null, foreign key(iduser) references user(id), title varchar(200) not null, content varchar(max) not null, rating int, creationdate datetime ); I'm getting an error at line 9 ne...
Given the two following tables : Gallery id | title | desc Site id | title | desc | url I've a tags system which can apply to both Gallery and Site tables. I'm wondering if I should do : TagMap tagId | entityId | applyTo Where applyTo could be 'site' or 'gallery' or use separate table like the following : TagGalleryMap tagId | g...
Hi guys, I am wanting to create a VB.Net app that checks a database and then prints out the latest orders, the database is mysql and i need it to periodatically check and only print new orders i.e. not print ones it has already printed out. Any advice would be greatly appriciated. Kyle ...
Here's my Zend code: <?php require_once ('Zend\Form.php'); class Sergio_Form_registrationform extends Zend_Form { public function init(){ /*********************USERNAME**********************/ $username = new Zend_Form_Element_Text('username'); $alnumValidator = new Zend_Validate_Alnum(); $user...
My form class: <?php require_once ('Zend\Form.php'); class Sergio_Form_registrationform extends Zend_Form { public function init(){ /*********************USERNAME**********************/ $username = new Zend_Form_Element_Text('username'); $alnumValidator = new Zend_Validate_Alnum(); $username ...
The best way to store images into MySQL is by storing the image location as a charater string. If you need to manipulate the image, then, the best way is to copy the image as a binary. How one can store images into binary form and how we can retrive them back? I don’t know anything about this technique. Please tell me how we can do thi...
In MySql I could have a table with an auto increment column and insert that way: INSERT INTO tbl VALUES(null, "bla", "bla"); Is there any way to do this with Microsoft SQL Server Express? Instead of this: INSERT INTO tbl(`v1`, `v2`) VALUES ("bla", "bla"); Thanks ...
I'm converting a PHP script as DB has been switched from MySQL to PostgreSQL. I know PG doesn't have the IF function but does have the CASE function. What is the best way to convert this MySQL statement? SELECT albums.id, albums.albumname, sum(if(((albums.id=allalbums.albumid) and (allalbums.photoid=...
Can someone give a demo? I'm using MySQL,but the idea should be the same! EDIT In fact I'm asking what's the difference between Doctrine_Relation and Doctrine_Relation_ForeignKey in doctrine? ...
Database i am using is MySQL 5.1. I specified, i believe, right connectionstring in my web.config. but when i run my web app. it throws this exception:- MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('root'@'%') does not exist Any help. Why am i getting this? ...
Here is what I'm trying to do: - i need a function that when passed as an argument an ID (for a category of things) will provide all the subcategories and the sub-sub categories and sub-sub-sub..etc. - i was thinking to use a recursive function since i don't know the number of subcategories their sub-subcategories and so on so here is w...
Hi, I built a class that allows me to do: $db->query($query); and it works perfectly, although if I want to do: $db->query($query); while($row = $db->fetch_assoc()){ $db->query($anotherquery); echo $db->result(); } it "breaks" the class. I don't want to constantly have to redeclare my class (eg: $seconddb = new database()...