|
Hello;
This is the scenario:
I have a MySQL server with a database, let's call it consolidateddb . This database a consolidation of several tables from various databases I have another MySQL server, with the original databases, these databases are production...
Started by Moutaz on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
I don't think MySQL provides any built-in way to move replication statements between databases it by manually altering the....
MySQL statement-based replication (basic replication) works by running the exact same statements was in.
|
|
I am working on a project needing me to work with multiple database connections. From what I have read, I should be able to switch between connections in the query itself, something like:
mysql_query("SELECT * FROM user_types", $db_core)or die(mysql_error...
Started by kilrizzy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use the db.table syntax in the query:
mysql_query("SELECT * FROM databas_ename.table_name", $db_core) or die(mysql_error());
The code you have in your question should work, except when both databases are on the same server....
|
|
I have table in mysql database which have field with datatype is datetime.
I want to save the datetime in this minute, for this I use " Now() ", but it does not work,
It just save in databaes.
Started by Hashim Al-Arab on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For more options see http://php.net/manual/en/function.date.php
If you've got a timestamp in PHP ... .
(Now(), ...)
without additional quotes around the function Now() date("g") this will return 12-hour format of an hour without leading zeros .
INSERT ...
|
Ask your Facebook Friends
|
Mer datafrågor. Kunskapen verkar ju slående ibland här.
Jag har en gästbok gjord i php och som ligger i en databas hos One.com
Nu har jag kopierat in några inlägg från en annan gästbok, och det är ju inga problem, la in dom direkt via phpmyadmin.
Men,...
Answer Snippets (Read the full thread at maskinisten):
Unix timestamp -> hur många sekunder sedan 1970
http://www.php.net/manual/en/function.mktime.php
http://php.net/manual/en/function.time.php
Last edited by Towil on 10:50:57, 22-03-2012; edited 1 time in total Tackar, det var så enkelt?
Har nu suttit... .
|
|
Hi, I have in the database words that include special character (in Spanish mostly, like tildes). In the database everything is saved and shown correctly with PHPmyAdmin, but when I get the data (using PHP) and display it in a browser, I get a weird character...
Started by Jonathan on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
"); $mysqli->query("SET NAMES 'utf8'");
Have MySQL translate it automatically
$conn = mysql_connect('host', 'user', 'password'); mysql_set_charset('utf8',$conn);
http://es.php.net/manual/en/function.mysql-set-charset.php
EDIT:....
|
|
KOD: 1: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > 2: <html xmlns= "http://www.w3.org/1999/xhtml" > 3: <head> 4: <meta http-equiv= "Content-Type" content...
Answer Snippets (Read the full thread at phpportalen):
Byt ut addslashes mot mysql_real_escape_string bland annat.
Du bör nog säkra den koden något.
|
|
Hi All,
I want to store the entired xml file into the databas and later parse this file as needed. I have done the following:
-- Create table
create table testxml(xmldata text)
insert into testxml selectl load_file('data.xml');
select * from testxml; ...
Started by Joanne Pham on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at mysql):
|
|
Hi All,
I want to store the entired xml file into the databas and later parse this file as needed. I have done the following:
-- Create table
create table testxml(xmldata text)
insert into testxml selectl load_file('data.xml');
select * from testxml; ...
Started by Joanne Pham on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at mysql):
|
|
Hi!
I got text in a database (mysql), and trying to get it into flash.
Normal characters (english and swedish) works just fine.
Now its time for Chinees characters.
So what I need help with is to get text from database (that part works), to display in...
Started by edited on
, 2 posts
by 1 people.
Answer Snippets (Read the full thread at flashkit):
If it might help, maybe I can send the swf file to look at! .
|
|
Hi!
I got text in a database (mysql), and trying to get it into flash.
Normal characters (english and swedish) works just fine.
Now its time for Chinees characters.
So what I need help with is to get text from database (that part works), to display in...
Started by edited on
, 2 posts
by 1 people.
Answer Snippets (Read the full thread at flashkit):
If it might help, maybe I can send the swf file to look at! .
|