Hello, We develop a web app in postgreSQL. For our blog which runs on the business web site, we want to run it on wordpress. Are we able to install the free version of mySQL and run the blog with it or do we require a commercial licence? Our web-app has nothing to do with mySQL. Thanks ...
I was using phpmyadmin to insert some dummy data into a table, and noticed it structured the insert like this: INSERT INTO `arc`.`transactions` ( `txn_id` , `date_time` ) VALUES ( '50005', CURRENT_TIMESTAMP ); Normally, I'd just not include the field "date_time" and the value is created by mySQL (as the field is of ty...
I have an application, it uses the libmysqlclient.so I wonder if I need GPL license on this application due to libmysqlclient be GPL or if I can continue the program in closed source EDIT: According to this site, I can use the libmysqlclient in a closed-source software. Just do not understand why the GPL "infects" the code so much ... ...
I have a form with many inputs, but not all inputs must be filled in. Form action is set to a php file, which checks which inputs are set and builds a query to query MySQL. Then I display the results on the main page, and the users may click on an ad to show. When clicked an ad, a new page opens with several options for the user (chang...
PDO and prepared statements are still kind of confusing to me, no matter how much I read about them so far. So I know they are more "secure" but is it really that important? I mean I can get the same end result using basic mysql with mysql_real_escape_string() and htmlspecialchars() right? ...
I am not at all familiar with ASP.NET membership/roles. This is my first time using it, and my first time trying ASP.NET MVC. When I create my first project for MVC, it gives me a lovely template to create an account. I was excited to see that I did not have to do this manually. However, it failed because it cannot connect to SQL Ser...
I am looking to implement a 'youtube related videos' style related content system. I have 5 tags/keywords for each of my pages, a title and a description. I would like to display links to the two most similar pages. I am guessing a mysql query based around order by relevance. many thanks. ...
I learnt about prepared statements when making a JDBC-enabled Java application, and my app uses a connection pooling layer that assures me that prepared statements are cached server-side and this gives a performance benefit. However, with PHP everything I've read says that they are only cached for the life of the page load. Generally I ...
Sorry if this is wrong or confusing I am very new to using classes and I would like to start learning more about using PDO with mysql. Here is an example code from php.net <?php /* Execute a prepared statement by passing an array of values */ $sth = $dbh->prepare('SELECT name, colour, calories FROM fruit WHERE calories < ? AND ...
hi, i try to insert data into mysql table in server using php server scripting, its working fine, is it any possibilites to insert data into mysql table without calling the php server scripting, thanks ...
hello i want to ask a small question here but i really don't know what is the answer of this question. i have a accounts table which has Username | Password the username is a primary key so its unique so is it necessary to put an ID column to the table ? if Yes, what is the benefit of that ? Thanks ...
I want to be able to fetch results from mysql with a statement like this: SELECT * FROM table WHERE amount > 1000 But I want to fetch the result constrained to a certain a month and year (based on input from user)... I was trying like this: SELECT * FROM table WHERE amount > 1000 AND dateStart = MONTH('$m') ...$m...
Hi all... I have a table with the following structure.... FIELD TYPE EXTRA faciltiy_id int auto_increment(Primary Key) hotel_id int facility_title varchar(20) facility_desc varchar(300) When i want to delete a row with a particular facility_id i use the code.... DELETE FR...
Hi, I've spent 4-5 hours or so in various forumns and at their websites researching reporting tools that can aid me in my development. I'm new to using tools like this and could use a bit of specific guidance. I'm working on an web app that will be hosted on one server, but accessed by multiple users through login. Each user will ha...
I have two different servers for mysql databases. First server is for master database and second server to act as slave. Now i need to synchronization all the changes being done on my master database to be applied to the slave database on real time basis. Please guide me with all the steps to implement real time mysql database synchroni...
So, I've created a site; using Mysql 5, Coldfusion 8 and Dreamweaver CS3. I have a 'GoDaddy' windows hosting plan - and have just uploaded my database. I have uploaded my site - But it doesn't work! I have an index.cfm page, so it should work, my URL's are correct. I'm not sure why thats not working!! Also, I am woundering if I need to ...
I need to get up to speed really quickly on programatically creating an manipulating a MySql database from C or C++. The d/b might be on the same machine, or might be remote. is there a "definitive" book I can read (maybe O'Reilly?), or a great tutorial website? Thanks, ~mawg(); ...
Hi All, Is there any method available to strip unwanted background content (external css) being submitted to server by FCKeditor? Currently many users are directly copying from web contents or from external editors like MS Word 7 which adds unwanted stuff in background while storing data to database. For e.g. when i copy pasted content...
I am trying to read a huge result set from mysql. Reading them in a straight-forward manner didn't work, as mysql tries to return all results together, which times out. I found the following piece of code which tells mysql to read the results back one at a time: stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql...
hi, i have a table like this: +------------------------+ |Key| value | name | +---+-------+------------+ 1 A john 2 B Mary 3 C Ben 4 A Ben 5 B john 6 C Mary how can i do a select which returns who has values of "A" and "B" (in t...