6 replies to this topic

[TioKibi]

Peguei um sistema de blog pra poder testar c o webscindiario ta funcionando..
So q tem um problema..ele pede pra fazer um table no banco de dados (axo q eh isso) com o seguinte:


#
# Table structure for table `blog`
#

CREATE TABLE blog (
id int(11) NOT NULL auto_increment,
title text NOT NULL,
content text NOT NULL,
date varchar(50) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping sample data for table `blog`
#

INSERT INTO blog VALUES (1, 'Sample Blog Entry', '<p>This is just a sample entry. Simple HTML tags are supported in this field.</p>\r\n\r\n<p>Tags Supported:</p>\r\n\r\n<p>&lt;p&gt;&lt;/p&gt; - Paragraph<br>\r\n&lt;br&gt; - Line Break<br>\r\n&lt;hr&gt; - Horizontal Line<br>\r\n&lt;ul&gt;&lt;/ul&gt; - Unordered List<br>\r\n&lt;li&gt;&lt;/li&gt; - List Item<br>\r\n&lt;a href&gt;&lt;/a&gt; - Hyperlink<br>\r\n&lt;a name&gt;&lt;/a&gt; - Named Anchor<br>\r\n&lt;font&gt;&lt;/font&gt; - Font<br>\r\n&lt;h1&gt;&lt;/h1&gt; through &lt;h6&gt;&lt;/h6&gt; - Heading Tags<br>\r\n&lt;b&gt;&lt;/b&gt; - Bold<br>\r\n&lt;em&gt;&lt;/em&gt; - Italic</p>\r\n\r\n', 'Thu 26th Jun, 2003 04:07 pm');
INSERT INTO blog VALUES (2, 'Sample Blog Entry II', '&lt;p&gt;&lt;/p&gt; - Paragraph\r\n&lt;br&gt; - Line Break\r\n&lt;hr&gt; - Horizontal Line\r\n&lt;ul&gt;&lt;/ul&gt; - Unordered List\r\n&lt;li&gt;&lt;/li&gt; - List Item\r\n&lt;a href&gt;&lt;/a&gt; - Hyperlink\r\n&lt;a name&gt;&lt;/a&gt; - Named Anchor\r\n&lt;font&gt;&lt;/font&gt; - Font\r\n&lt;h1&gt;&lt;/h1&gt; through &lt;h6&gt;&lt;/h6&gt; - Heading Tags\r\n&lt;b&gt;&lt;/b&gt; - Bold\r\n&lt;em&gt;&lt;/em&gt; - Italic', 'Thu 26th Jun, 2003 04:29 pm');


mas onde eu ponho isso?No editor do banco de dados do webscindiario nao te espaco pra tudo isso, q q eu faco?

[AirFight]

Bom vc pode criar um arquivo instalar.php e executar isso atraves desse arquivo.

um exemplinho

<?
include("config.php");

$query = "CREATE TABLE teste";

mysql_query($query);

header("Location: paginadeconfirmacao.php");

?>

Edição feita por: AirFight, 14/04/2004, 19:16.

[together]

CREATE TABLE blog (
id int(11) NOT NULL auto_increment,
title text NOT NULL,
content text NOT NULL,
date varchar(50) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;


INSERT INTO blog VALUES (1, 'Sample Blog Entry', '<p>This is just a sample entry. Simple HTML tags are supported in this field.</p>\r\n\r\n<p>Tags Supported:</p>\r\n\r\n<p>&lt;p&gt;&lt;/p&gt; - Paragraph<br>\r\n&lt;br&gt; - Line Break<br>\r\n&lt;hr&gt; - Horizontal Line<br>\r\n&lt;ul&gt;&lt;/ul&gt; - Unordered List<br>\r\n&lt;li&gt;&lt;/li&gt; - List Item<br>\r\n&lt;a href&gt;&lt;/a&gt; - Hyperlink<br>\r\n&lt;a name&gt;&lt;/a&gt; - Named Anchor<br>\r\n&lt;font&gt;&lt;/font&gt; - Font<br>\r\n&lt;h1&gt;&lt;/h1&gt; through &lt;h6&gt;&lt;/h6&gt; - Heading Tags<br>\r\n&lt;b&gt;&lt;/b&gt; - Bold<br>\r\n&lt;em&gt;&lt;/em&gt; - Italic</p>\r\n\r\n', 'Thu 26th Jun, 2003 04:07 pm');
INSERT INTO blog VALUES (2, 'Sample Blog Entry II', '&lt;p&gt;&lt;/p&gt; - Paragraph\r\n&lt;br&gt; - Line Break\r\n&lt;hr&gt; - Horizontal Line\r\n&lt;ul&gt;&lt;/ul&gt; - Unordered List\r\n&lt;li&gt;&lt;/li&gt; - List Item\r\n&lt;a href&gt;&lt;/a&gt; - Hyperlink\r\n&lt;a name&gt;&lt;/a&gt; - Named Anchor\r\n&lt;font&gt;&lt;/font&gt; - Font\r\n&lt;h1&gt;&lt;/h1&gt; through &lt;h6&gt;&lt;/h6&gt; - Heading Tags\r\n&lt;b&gt;&lt;/b&gt; - Bold\r\n&lt;em&gt;&lt;/em&gt; - Italic', 'Thu 26th Jun, 2003 04:29 pm');

Tenta agora

[**K@T@T@U**]

ai,o q esse TYPE=MyISAM faz????

[fly2k]

è o tipo de tabela do mysql...
pesquise mais em http://www.mysql.org