[Opinion: Multiple websites same data: Individual db's or single db?]

Thank you very much!

[Opinion: Multiple websites same data: Individual db's or single db?]

Shared. MySQL isn't going to look at your data and say "oh, this is the exact same as off in this other table" and then reuse results. That's your job, and by that I mean not having the same data in multiple tables.

Thanks for that info.

 

I left out an important part of my question:

 

While each of the websites uses the same geographic data (zip codes, city/state geocodes, etc.) each website has it's own version of data specific to that website. For instance, one site maintains a list of grow stores and has a table 'locations' that contains all of those locations. Another site maintains a list of motorsports shops with it's own, structurally different version of the table 'locations'.

 

If each site has it's own db and also pulls from a shared db, two MySQL db connections would often be required instead of one.

 

Is the processing cost of 2 PDO/MySQL connections substantial enough to warrant keeping multiple copies of the same data in multiple databases? Or is the cost of 2 db connections so insignificant that it makes sense for 4 or 5 sites to use a shared database AND have their own unique database?

 

My concerns are 1. Additional processing required to use 2 database connections per site and 2. Possible delays due to multiple sites sharing the same database tables vs. each site using it's own copy.

 

Thanks for your input!

[Opinion: Multiple websites same data: Individual db's or single db?]

Hello!

 

I have five websites on a single server, and each website uses the same geographic data, for instance US zip codes and city/state latitudes and longitudes. Each website uses it's own copy of these "large" tables.

 

I would like to avoid having to maintain the same data in 5 databases, but I am more concerned with database performance, e.g., the speed at which the data is retrieved for each website.

 

Question: Should I set up a new separate database that contains the shared tables for all websites and allow each website to connect to this new database for shared data? Or is it better for each website have it's own copy of the duplicate tables?

 

Thanks for any info!

 

Cheers

[Editing arrays]

true !== "true"

[Could nayone help with this Parse error: syntax error]

the way i find php.ini is to run phpinfo() on the command line:

 

php -r 'phpinfo();'

 

or if you're running a php page:

 

<?php
phpinfo();
?>

 

One of the pieces of information listed is the location of php.ini

[need help joining tables fields through a relational database]

what do you mean by "not working?" what is happening or isn't happening. and show more than one line of code, if possible.

[disable register]

what happens when you run it? does it do what you expect, or not?

[How many queries on page load??]

i think your script is a script that can count the number of queries executed. start a counter at 0 and add 1 each time a query is executed. at the end, output counter.

[Connect to MYSQL Database]

the error tells you: the username or password is not valid for connecting to that database.

 

Access denied for user 'esolarch_ms'@'localhost' (using password: YES)

[mysql_update_id]

what if you have multiple duplicate keys? this is one reason I check for duplicate key instead of throwing data at the table with a 'on duplicate key' to catch my mistakes. my 2 cents.

[Can a $_POST[$variable] use a variable in the argument position?]

HTML:

<code>

<input type="text" name="Participant_P[]">

<input type="text" name="Participant_P[]">

<input type="text" name="Participant_P[]">

</code>

 

PHP:

<code>

$P0 = $_POST['Participant_P'][0];

$P1 = $_POST['Participant_P'][1];

$P2 = $_POST['Participant_P'][2];

</code>

[php mail function and google apps]

what do I do in this case?

 

you'll have the best luck sending emails out using a domain that actually resolves to the server sending the email. You will not be able to sit a google.com domain on your server, so you'll have to use a non-google.com sending email address.

[preg_match that include string and variable]

i think you want preg_replace.

 

http://php.net/manual/en/function.preg-replace.php

 

or if you mean you want $title[1] to be part of the pattern, you're doing it correctly.

[Submit and convert textarea into HTML and insert into SQL table]

I use tiny mce for wysiwyg text editing. then just enter the text field into the database the usual way.

[multiple form submits]

you're doing it the right way, using onchange. do you get any javascript errors? instead of posting the pre-compiled code, you might want to post the HTML output so we can see if there is a problem.

[media player and php variables]

when posting an error, it is best to include the entire error, especially the line number. but taking a look at the code, this should be:

 

echo '<param name="flashvars" value="mp3='.$file.'" />';

 

or the way I prefer to do it, using single quotes within tags:

 

echo "<param name='flashvars' value='mp3=$file' />";

[Application Data (Cities & Zip)]

What other ways are there for performing a radius search?

[obtain such a reference in the script]

No, not using just PHP or any server-side language. You might have javascript send the value to PHP, though.

[To PDO or not to PDO?]

As a LAMP Developer, I don't care about other databases except in cases where I need to (permanently) convert from something else to MySQL. So I only use MySQL functions. my 2 pennies.

[Recursive Delete Function]

you declare the function, but you never call it.

 

http://www.tizag.com/phpT/phpfunctions.php

[Hierarchy breakdown from HTML list?]

what happened when you implemented your logic?

[Show error to the side of the input feild (Form)]

If there is an error for a specific field, echo an error statement to the right of it.

[Notice: Undefined variable: page error! URGENT!]

$page is not defined. it is not set. the code references $page, but $page is not defined. hence the error.

[Trouble creating active links with PHP and .inc files]

you can't put <?php tags within a string like you've got it for $main_nav = '

 

you'll need to perform the class/no class logic differently.

[Avoiding Accidental Resubmission?]

i use a session variable to indicate that the form has already been submitted by the current user.