Search Results

Search found 14874 results on 595 pages for 'mysql connector'.

Page 288/595 | < Previous Page | 284 285 286 287 288 289 290 291 292 293 294 295  | Next Page >

• Hotel Reservation system Database schema

  - by SpikETidE

  Hi Everyone.... I am about to develop a online hotel reservation system...using php and mysql... I have some doubts about my current database schema and the business logic to get the hotels in which rooms are free between two particular dates... Does anyone know of some kind of tutorial where i can get some idea about the hotel reservation schema and the business logics that should be used in the system...? Thanks for your suggestions....

  Read the article

• Database replication with composite keys?

  - by Chad Johnson

  According to the MySQL documentation on database replication, "All tables replicated using row-based replication must have explicit primary keys." Is it safe to assume that database replication will work with a composite keys?

  Read the article

• get state and county a city belongs to with geonames database?

  - by fayer

  i have downloaded whole database from geonames.com and imported all countries into mysql. i wonder how i can get the continent, country, state, county when i got a city's id? cause i want to make a cascading list menu with these information. thanks!

  Read the article

• Store IPv6 in database

  - by poru

  What's the best practise to store IP's with PHP in MySQL database? There's a function called ip2long - but this is just for IPv4. But what about IPv6? I know a php function that is for IPv6 IP's, but it doesn't work on Windows with PHP < Version 5.3

  Read the article

• Msql Partitioning - Key vs Hash vs List vs Range

  - by Imran Omar Bukhsh

  I went through some of the documentation of mysql but cannot understand the difference in the following ways of partitioning : Key vs Hash vs List vs Range.Can someone explain in pure english? Also we have the following table: How do we partition by forum_id? CREATE TABLE IF NOT EXISTS `posts_content` ( `id` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `forum_id` int(11) NOT NULL, `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=79850 ; Thanking you

  Read the article

• Datetime and date-range comparsion

  - by Ockonal

  Hello guys, I have datetime-row in mysql database. I have to check time between now and that date using php. If the range is bigger then 1 month - do somtething. I tried something like this: $dateFromMysql = strtotime($rowData); $currentDate = date("m/d/y g:i A"); And then comparsion by hands. It's ugly.

  Read the article

• When selecting an amount of rows, how can I select a percentage of a percentage?

  - by Rob

  Fairly simple question: Say I want to use 30 percent of the rows in the table of my MySQL table. However I also have a user input where they can select a percentage of that percentage For example: $_GET['percentage']% of 30% so we say that $_GET['percentage'] = 30 How would I select 30% (or $_GET['percentage']) of 30% to use in a while loop?

  Read the article

• loading multiple line query in one row

  - by bharath

  Hi, How to load a multiple line query in one row using mysql.The data is stored in a text file. For example: "GGAGTTGTGGGAGTGGAGGAGGAAGAGGCGGTGGGGAGTACGGGGGCTGGTCCCAGAAGATGGCGGAGGC GGGGGATTTCTGGTAGGTCCTACTTTAGGACAAGATGTGGTGGTACTGTTGAAGCGTCAGTCTTTGATTC" Thanks in advance.

  Read the article

• SQL: Join vs. subquery

  - by Col. Shrapnel

  I am an old-school MySQL user and always preferred JOIN over sub-query. But nowadays everyone uses sub-query and I hate it, dunno why. Though I've lack of theoretical knowledge to judge myself if there are any difference. Well, I am curious if sub-query as good as join and there is no thing to worry about?

  Read the article

• Get 10 Most Entered Entries

  - by Belgin Fish

  Hi, I'm just wondering if it's possible to retrieve the the most entered entries from the mysql database It's like this : ID - Value Id is auto increment, and value is the text that is being entered, i'd like to have it display the top 10 most entered terms, how could i do that?

  Read the article

• deploying WAMP -> live site - any random tips?

  - by Haroldo

  In the next few weeks I'll be taking my site from the localhost (WAMP) and puting it on a new server. This will be the first site, on my first server, so basically...i'm a noob! This must be an important moment for any independent web developer / small business so i'd love to hear about some experiences, mistakes and system default security holes that one should fix straight away... I'm using php, mysql, cpanel and WHM, and looking for tips like "Turn off error reporting in PHP"

  Read the article

• Password Validation

  - by Humpton

  Hi there. Using mysql and php Is there any reason / value when checking a password to query the database using the user name and password (after sanitizing, of course) and recording a failed attempt when no rows are returned vs querying the database using the user name and then comparing the return password string? EDIT: To those who mentioned it below, yes the password is hashed up in the database.

  Read the article

• Lightweight multi os monitoring plateform

  - by user293995

  Hi, I have a project where the is windows, freebsd and linux servers. I have to monitor some services : mysql replication status www status status with regexp on a webpage space on disk Is there open source software to do this and rapid to deploy ? Thanks in advance Best regards

  Read the article

• select rows with column that is not null?

  - by fayer

  by default i have one column in mysql table to be NULL. i want to select some rows but only if the field value in that column is not NULL. what is the correct way of typing it? $query = "SELECT * FROM names WHERE id = '$id' AND name != NULL"; is this correct?

  Read the article

• Frequency Table by user in SQL

  - by Roberto

  Very basic SQL question (DB is MySQL): I want a table of number of transactions by users. User ID Transaction count 1 43 2 213 3 0 4 23 5 0 In a table I have the two relevant records (user_id and buy_count). How could I get the table I want? Thanks, Roberto

  Read the article

• Search tamil fonts in mysql and php

  - by rekhasathvika

  Hi, How to search tamil fonts and retrieve data from mysql and show the result using php? Regards, Rekha http://hiox.org

  Read the article

• PHP URL Security Question

  - by TaG

  I want to have users store the url in my database I'm using php mysql and htmlpurifier I was wondering if the following code was good way to filter out bad data? Here is the Partial PHP code. $url = mysqli_real_escape_string($mysqli, $purifier->purify(htmlspecialchars(strip_tags($_POST['url'])));

  Read the article

• why this left join query failed to load all the data in left table ?

  - by lzyy

  users table +-----+-----------+ | id | username | +-----+-----------+ | 1 | tom | | 2 | jelly | | 3 | foo | | 4 | bar | +-----+-----------+ groups table +----+---------+-----------------------------+ | id | user_id | title | +----+---------+-----------------------------+ | 2 | 1 | title 1 | | 4 | 1 | title 2 | +----+---------+-----------------------------+ the query SELECT users.username,users.id,count(groups.title) as group_count FROM users LEFT JOIN groups ON users.id = groups.user_id result +----------+----+-------------+ | username | id | group_count | +----------+----+-------------+ | tom | 1 | 2 | +----------+----+-------------+ where is the rest users' info? the result is the same as inner join , shouldn't left join return all left table's data? PS:I'm using mysql

  Read the article

• How do I display a quote for 24 hours

  - by mathew

  I want to display a quote on my site for daily basis. after 24 hours it should change. quotes are stored in MySQL database. how do I do this with PHP Thanks Mathew

  Read the article

• function for converting time to number of seconds

  - by Brian

  On our site, we have a lot of swimming times that we would like to convert to seconds. i.e. 1:23:33.03 or 58:22.43. Is there a PHP function that can do this? A MySQL function?

  Read the article

• SQL GUI Programs

  - by jake

  Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.

  Read the article

• how to write bulk of data into xml file from backend and i want to bind the xml file into list?

  - by maniohile

  Hi, I want to write the bulk of data into xml file ,the data coming from the backend(mysql) using cgi by httpservice, read the xml file and bind it into list... can anyone send the sample code for this? Thank's in advance..

  Read the article

• date() is showing December 1969

  - by Doug

  $sql = "SELECT * FROM news ORDER BY `news_id` DESC LIMIT 1"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); $date = $row['time_posted']; echo "<i> " .date("Y/m/d", $date) . "</i>: "; I used timestamp in mysql. So, what's the problem?

  Read the article

• ORDER BY letters and not numbers of a field

  - by Jon

  Is there a way to order mysql results by the first letter and ignore numbers? For example, I have a list of addresses: 123 Main Street 456 Second Street 234 Third Street and I want to order by the street name and ignore the street number. Is there an easy way to do this?

  Read the article

• creating a primary key format

  - by ryn6

  how do i create a primary key for an account with a format like this: ABC-123 ABC-124 ABC-125 another example: BCA-111 BCA-112 BCA-113 and so on. by the way im using mysql.is it possible to do auto increment when using this format?

  Read the article

< Previous Page | 284 285 286 287 288 289 290 291 292 293 294 295  | Next Page >