Everything posted by Meltdown
-
Php question...
Can I call the page with an include: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(70, 'contact', 4, NULL, '<?php { include("contact.php");} ?>', 'NULL', 'text'); This particular code doesn't work but at least it isn't throwing an error when I update the database.
-
Php question...
Here is the error I recieve when updating my database: Thanks
-
Php question...
My new contact link is added but the specific page content for that page is not showing (It should be contact form). I see that other individual page content was added into the database directly, as shown below: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(11, 'links', 1, NULL, '<p> </p>\r\n<h3 style="text-align: left">AskART The artists Bluebook</h3>\r\n<p style="text-align: left"><a href="[url="http://www.test.com%22%3ehttp//www.test.com%3C/a%3E%3C/p%3E/r/n%3Cp%3E %3C/p%3E"]http://www.test.com">http://www.test.com</a></p>\r\n<p> </p>'[/url], NULL, 'text'); But I am unsuccessful I attempt to do the same with the contents of my contact page: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'contact', 1, NULL, '<p><div align="center"><table border="0" width="480"><tr><td> <font face="Verdana" size="2"><form enctype='multipart/form-data' action='http://www.test.com/contact/forms/process.php' method='post'><div align="center"><h2 align="center"><em>Contact</em></h2><table border="0" cellspacing="1" style="border-collapse: collapse" width="45%" cellpadding="5"><tr><td colspan="3" height="16" width="100%"><font size="2" face="Verdana"><font face="Verdana" size="2" color="#000000"><!- You can add a brief form description here-->Commissions are welcome upon request, for further information please e-mail the Artist. <p> </p></font></b></font></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Name</td><td height="30" width="469"><font face="Verdana"><input type=text name='Name'></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Email</td><td height="30" width="469"><font face="Verdana"><input type=text name='Email'></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Message</td><td height="30" width="469" ><font face="Verdana"><textarea name='Message' rows=5 cols=35></textarea></td></tr><tr><td colspan="3" height="25" width="537"><p align="center"><font face="Verdana" size="2"><input type=submit value='Submit Form'> <input type=reset value='Reset Form'></font></td></tr></table><p align="center"> </p><p align="center"> </p></div></form></font></td></tr></table></p>', 'NULL', 'text'); Any thoughts? Thank you!
-
Php question...
OK, it looks like I've got that worked out.
-
Php question...
I've finished updating the home page and creating the contents of the Contact Us page. However, I'm stumped as to how to add the new Contact Us link to the navagation bar. below is the database contents. I assume that the new link must be added here as well as to the index.php page. How would I go about that? -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] -- -- Host: 62.149.150.67 -- Generation Time: Jun 03, 2010 at 05:17 PM -- Server version: 5.0.82 -- PHP Version: 5.2.13 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `Sql165002003_1` -- -- -------------------------------------------------------- -- -- Table structure for table `accesso` -- CREATE TABLE IF NOT EXISTS `accesso` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(20) NOT NULL default '', `password` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `token` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `session` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `ip` varchar(15) character set latin1 collate latin1_bin NOT NULL default '', `level` int(2) NOT NULL default '0', PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `accesso` -- INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(1, 'guidoeffe', '06f074501e8aefaae85df98f42629b2e', '7d61464a0151b5a216ec3b1ae3278b83', '3631a5210845839ae70b461e8d7882b8', '159.213.32.228', 1); INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(2, 'oliviars', '0b16d2ffa469a9e7d06ce4033eafa5dc', '7bf936bafc2bf85671d13fa8bf1e0ab3', 'fdc6e3dba56a286bdecc00ca33233026', '151.49.47.233', 0); INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(3, 'eusebio', '0b16d2ffa469a9e7d06ce4033eafa5dc', 'd0d3b63061edeb714557ba2ffdcb2f0a', '992b35ab052e5a3ac820c9b34b9d00d8', '79.23.122.33', 0); -- -------------------------------------------------------- -- -- Table structure for table `images` -- CREATE TABLE IF NOT EXISTS `images` ( `id_image` int(9) NOT NULL auto_increment, `section` varchar(100) collate utf8_unicode_ci NOT NULL, `file` varchar(255) collate utf8_unicode_ci NOT NULL, `type` varchar(100) collate utf8_unicode_ci NOT NULL default 'portrait', `title` varchar(100) collate utf8_unicode_ci NOT NULL, `description` varchar(255) collate utf8_unicode_ci default NULL, `sold` varchar(50) collate utf8_unicode_ci default NULL, `dimension` varchar(100) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id_image`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=140 ; -- -- Dumping data for table `images` -- INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(1, 'all', '', 'portrait', 'Empty frame', NULL, '', NULL); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(2, 'all', '', 'landscape', 'Empty frame', NULL, '', NULL); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(42, 'landscapes', '42_RADDAINCHIANTI60X50cm.jpg', 'landscape', 'Radda in chianti', 'Oil on Linen', 'sold', '60 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(64, 'still-life', '64_40x50.jpg', 'portrait', 'Myrna', 'Oil on Linen', 'sold', '40 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(86, 'landscapes', '86_drive.jpg', 'portrait', 'A drive through Tuscany', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(54, 'portraits', '54_ALESSIAINSARDINIA90X70cm.jpg', 'landscape', 'Alessia in Sardinia', 'Oil on Linen', NULL, '90 x 70 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(48, 'portraits', '48_SILVESTRO70X90cm.jpg', 'portrait', 'Silvestro', 'Oil on Linen', NULL, '70 X 90 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(49, 'portraits', '49_JOSEPH50X60cm.jpg', 'portrait', 'Joseph ', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(57, 'still-life', '57_CERAMICVASEWITHONIONSANDEGG50X40cm.jpg', 'landscape', 'Ceramic vase with onions and egg', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(56, 'still-life', '56_BOOKKEYANDCLAYVASE40X50cm.jpg', 'portrait', 'Book, key and clay vase', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(94, 'landscapes', '94_DSC01028copia.jpg', 'landscape', 'Chianti Sangiovese', 'Oil on Linen', NULL, '80 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(59, 'still-life', '59_CABBAGE,LEEKSANDPEPPERONI50X40cm.jpg', 'landscape', 'Cabbage, leeks, and pepperoni', 'Oil on Linen', NULL, '50 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(60, 'still-life', '60_OILWITHPEPERONCINO50X35cm.jpg', 'landscape', 'Oil with peperoncino', 'Oil on Linen', NULL, '50 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(39, 'portraits', '39_ALESSIA90X120cm.jpg', 'portrait', 'Alessia', 'Oil on Linen', NULL, '90 x 120 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(110, 'still-life', '110_DSC01037copia.jpg', 'portrait', 'Copper pitcher with rosemary and orange 40 x 60 cm oil on linen', 'Oil on Linen', NULL, '40 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(61, 'still-life', '61_JAPANESETEAPOT40X30cm.jpg', 'landscape', 'Japanese tea pot', 'Oil on Linen', NULL, '40 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(62, 'portraits', '62_DSC_7286.jpg', 'portrait', 'Marco', 'Oil on Linen', NULL, '60 x 100 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(63, 'landscapes', '63_DSC_7292.jpg', 'landscape', 'Tuscan countryside', 'Oil on Linen', NULL, '60 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(65, 'still-life', '65_DSC_7290.jpg', 'portrait', 'Carnival in Venice', 'Oil on Linen', NULL, '50 X 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(66, 'still-life', '66_DSC_7293.jpg', 'landscape', 'Bronze pot and Lemons', 'Oil on Linen', NULL, '60 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(67, 'still-life', '67_DSC_8401.jpg', 'landscape', 'Gubbio', '60 X 40 cm', 'sold', 'Oil on Linen'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(81, 'portraits', '81_stefania.jpg', 'portrait', 'Stefania', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(84, 'landscapes', '84_sanMichele.jpg', 'landscape', 'Monte San Michele', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(80, 'portraits', '80_nestor.jpg', 'portrait', 'Nestor', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(82, 'portraits', '82_giuseppe.jpg', 'portrait', 'Joseph 2008', 'Oil on Linen', NULL, '60 x 100 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(83, 'portraits', '83_roni.jpg', 'portrait', 'Roni', 'Oil on Linen', NULL, '60 x 80 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(85, 'landscapes', '85_fields.jpg', 'portrait', 'Fields of Tuscany', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(87, 'landscapes', '87_balena.jpg', 'landscape', 'Humpback Whale journey to Maui', 'Oil on Linen', NULL, '100 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(88, 'still-life', '88_porcini.jpg', 'landscape', 'Porcini ', 'Oil on Linen', NULL, '20 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(89, 'still-life', '89_japan.jpg', 'landscape', 'Antique Japanese Tea Pot', 'Oil on Linen', NULL, '30 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(90, 'still-life', '90_olive.jpg', 'portrait', 'Wine and Olives', 'Oil on Linen', NULL, '20 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(91, 'still-life', '91_copper.jpg', 'portrait', 'Copper Tea Pot With Red Onions', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(92, 'landscapes', '92_campo.jpg', 'portrait', 'Countryside', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(100, 'still-life', '100_BEETROOTSANDAPPLES40X50cmcopia.jpg', 'landscape', 'Beetroots and apples', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(130, 'portraits', '130_DSC01486.jpg', 'portrait', 'Giuseppe', 'CHARCOAL ON PAPER', NULL, '40 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(131, 'still-life', '131_DSC01488.jpg', 'portrait', 'Orchid', 'Oil on Linen', NULL, '50 x60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(97, 'still-life', '97_DSC01037copia.jpg', 'portrait', 'Copper pitcher with rosemary and orange', 'Oil on Linen', NULL, '40 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(134, 'portraits', '134_DSC01517copia.jpg', 'portrait', 'Victoria', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(101, 'still-life', '101_FRUITSANDSILVERMUG25X35cmcopia.jpg', 'landscape', 'Fruits and silver mug', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(132, 'still-life', '132_DSC01493.jpg', 'portrait', 'Old Vase with fruits', 'Oil on Linen', NULL, '30 X 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(133, 'portraits', '133_DSC01516copia.jpg', 'portrait', 'Emily', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(106, 'landscapes', '106_BALLEDIFIENO60X90cmcopia.jpg', 'landscape', 'Balle di Fieno', 'Oil on Linen', NULL, '60 x 90cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(107, 'still-life', '107_DSC01050copia.jpg', 'landscape', 'Old bean pot', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(108, 'still-life', '108_ITALIANBREAKFAST40X60cmcopia.jpg', 'landscape', 'Italian Breakfast', 'Oil on Linen', NULL, '40 x 60 cm'); -- -------------------------------------------------------- -- -- Table structure for table `link` -- CREATE TABLE IF NOT EXISTS `link` ( `codice` int(11) NOT NULL auto_increment, `descrizione` varchar(250) default NULL, `url` varchar(250) default NULL, `target` varchar(10) NOT NULL default '_self', `ordine` int(11) default NULL, KEY `codice` (`codice`), KEY `ordine` (`ordine`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Link' AUTO_INCREMENT=26 ; -- -- Dumping data for table `link` -- INSERT INTO `link` (`codice`, `descrizione`, `url`, `target`, `ordine`) VALUES(23, 'Web/Project Coordination', 'http://www.jmiltongroup.com', '_blank', NULL); INSERT INTO `link` (`codice`, `descrizione`, `url`, `target`, `ordine`) VALUES(19, 'Forence Gospel Choir School', 'http://www.fgcschool.com', '_blank', 1); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE IF NOT EXISTS `pages` ( `id_page` int(9) NOT NULL auto_increment, `section` varchar(100) collate utf8_unicode_ci NOT NULL, `number` int(3) NOT NULL default '1', `images` varchar(255) collate utf8_unicode_ci default NULL, `text` text collate utf8_unicode_ci NOT NULL, `message` varchar(255) collate utf8_unicode_ci default [email=""]'test@test.com'[/email], `structure` varchar(100) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id_page`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(50, 'still-life', 2, '66;64;67;90', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(51, 'landscapes', 3, '63;1;87;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(33, 'portraits', 2, '49;80;39;54;83', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(37, 'landscapes', 1, '94;86;106;85', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(11, 'links', 1, NULL, '<p> </p>\r\n<h3 style="text-align: left">AskART The artists Bluebook</h3>\r\n<p style="text-align: left"><a href="[url="http://www.aart.com"]http://www.aart.com[/url] \r\n '">http://www.aart.com">http://www.aart.com</a></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(38, 'still-life', 1, '108;131;101;132', '', NULL, 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(64, 'still-life', 4, '59;65;57;97', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(49, 'landscapes', 2, '42;92;84;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(53, 'bio', 1, NULL, '<p><font size="3"><font face="Times New Roman"><font color="#000000"> <img border="0" hspace="10" alt="" vspace="1" align="left" width="128" height="161" src="/img/img_text/b 50x60(5).jpg" /></font></font></font></p>\r\n<p>Olivia Santiago <b>was born and raised in Kahuku</b>, on the island of Oahu, Hawaii. She attended the University of Hawaii, at Windward, Kaneohe. For 2 years, she studied under artist professor <b>Snowden Hodges </b>who specializes in painting and drawing of the old masters, such as <i>Peter Paul Rubens</i>.</p>\r\n<p> </p>\r\n<p>Shortly after, Olivia furthered her <b>studies in Florence</b>, Italy attending <i>Charles Cecil Studio</i>, there she continued training in naturalistic tradition drawing and painting which dates back to <i>Titian</i>, <i>Van Dyck </i>and <i>Velàzques</i>, after which she remained in Florence and studied privately on her own for 3 years.</p>\r\n<p><o:p> </o:p></p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal">In 2004 she entered <b>Atelier Rebecca Harp in Florence</b>, Italy. Rebecca is an artist and teacher who structures her work in tradition of the old masters.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal">Thanks to Rebecca’s cunning guidance, Olivia became more aware of the importance to communicate visually. </p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"> </p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><b>She currently paints</b> in her studio.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><o:p> </o:p></p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><b>Olivia resides</b> in Florence with her husband and still profoundly inspired by the Masters of Art.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"> </p>\r\n<h4><b>For informations about prices and commissions please contact the artist</b></h4>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><span lang="EN-GB"><font size="3"><font color="#000000"><font face="Times New Roman"><o:p></o:p></font></font></font></span></p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(68, 'events', 1, NULL, '<p><img width="460" height="325" alt="" src="/img/img_text/image/art%20poster.jpg" /></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(54, 'still-life', 3, '107;56;61;91', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(69, 'events', 1, NULL, '<p><img height="308" width="220" alt="" src="/img/img_text/image/_FIL2884xxx%20copia.jpg" /></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(66, 'still-life', 5, '89;1;60;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(67, 'still-life', 6, '2;1;2;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'portraits', 1, '82;134;81;62;133;48', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'contact', 1, NULL, '', "[email="test@test.com"]test@test.com[/email]", 'text');</P> Thank you!!
-
Php question...
Hmmm... I can see the nav bar in the html of the home page but it is not actually showing up on the page itself. Could there be an if or elseif statement that is blocking the nav bar from appearing on the home page? If one of you gets a moment, could you please take a look at the index.php page I posted (post #6 in this thread) to see if that may be the case? Thanks!
-
Php question...
If you look at the index.php that I posted earlier (post #6 in this thread) you'll see that the navigation links (Home, Portrait etc.) are listed twice. Is there a logical reason for this? I would like to reproduce the same navigation bar found on all other site pages on the index page, as well. How would I go about that? Thanks!
-
Php question...
I'm in...! I'll dig around a bit and bother you later with annoying questions I appreciate the effort - I've always meant to install Xampp. It's good tohave it in place, no matter what the outcome of this project.
-
Php question...
OK, that did it - Thanks! Should I enable intranet settings on my localhost browser? Hmmm... I'm still having trouble accessing the home page on my localhost. Would the passwords still be the same or should I remove/change them?
-
Php question...
Sorry to be such a pain, Pat - I keep getting an error on import. It could be my connection details. Is the only change I'm going to make to the connection details that the hostname is "localhost"? [b]Error[/b] [b]SQL query:[/b] -- -- Database: `Sql160004_1` -- -- -------------------------------------------------------- -- -- Table structure for table `accesso` -- CREATE TABLE IF NOT EXISTS `accesso` ( `uid` int( 11 ) NOT NULL AUTO_INCREMENT , `username` varchar( 20 ) NOT NULL default '', `password` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `token` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `session` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `ip` varchar( 15 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `level` int( 2 ) NOT NULL default '0', PRIMARY KEY ( `uid` ) , UNIQUE KEY `username` ( `username` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; [b]MySQL said: [/b][url="http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html"][img=./themes/original/img/b_help.png][/url] #1046 - No database selected
-
Php question...
Import it using xampp/MySql/admin/import? And you said a text file - Not a sql file?
-
Php question...
Thanks for that. I have successfully installed Xampp and have access to localhost. How exactly can I use it in this instance? Should I copy the entire site to xampp/htdocs? Hmmm... I copied my index.php (deleting the xampp index.php & index.html) to htdocs and am getting the dreaded "Trojan Horse" message from Avast again, plus the following error: [b]Warning[/b]: require_once(../Connections/santiago_ado.php) [[url="http://localhost/function.require-once"]function.require-once[/url]]: failed to open stream: No such file or directory in [b]C:\xampp\htdocs\index.php[/b] on line [b]5[/b] [b]Fatal error[/b]: require_once() [[url="http://localhost/function.require"]function.require[/url]]: Failed opening required '../Connections/santiago_ado.php' (include_path='.;C:\xampp\php\PEAR') in [b]C:\xampp\htdocs\index.php[/b] on line [b]5[/b] Thanks
-
Php question...
Is it possible to create a simple test environment where I can make page modifications without affecting the existing site?
-
Php question...
And what about this idea to avoid trying to build a page using php: Right now the index.php is the default page. If I put in an index.htm it becomes the default. Couldn't I create my html home page, upload it as index.htm and then just update the links within the database to point to it rather than the php page? Sorry if this is inane...
-
Php question...
Thanks Pat, this really is quite generous of you. My php experience is limited to working with existing php structures, such as Zen Cart. Since I have been building Zen Carts commercially for some time, I have logged a good number of hours within that environment but unfortunately I've generally avoided database work like the plague. I'll go and take a good look around and see if I can get my head around it. A question: Where do you do the database work? Within the database itself or in a notepad editor that is then copied and pasted...? Another question; If I "view source" on the home page I see a basic html page but none of the php that makes up the site. Does this mean that I will be able to create my html page using my regular tools and then plug it in to the php of the index.php? If so, any idea why my last attempt at doing so generated a "Trojan Horse" warning? Thanks
-
Php question...
Yeah, what was that all about?? I had downloaded the original index.php and made a minor modification (added text to the <title>) to confirm that I had access. A few days later this "Trojan horse" thing appears. I've now reloaded the original index.php which corrected the issue. Files that I see when I access the site via ftp: admin include connections cgi-bin _mmServerscripts adodb guido img includes_old Pages: index.php index2a.php index4.php index_off.php modules.php popup.php test.php Below is the index.php - Thaks for your help! <?php require_once('Connections/santiago.php'); ?> <?php //Connection statement require_once('Connections/santiago_ado.php'); $pages = explode("|",$_GET['p']); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $currentPage = $_SERVER["PHP_SELF"]; $maxRows_sections = 1; $pageNum_sections = 0; if (isset($_GET['pageNum_sections'])) { $pageNum_sections = $_GET['pageNum_sections']; } $startRow_sections = $pageNum_sections * $maxRows_sections; $colname_sections = "-1"; if (isset($pages[0])) { $colname_sections = $pages[0]; } mysql_select_db($database_santiago, $santiago); $query_sections = sprintf("SELECT * FROM pages WHERE `section` = %s ORDER BY `number` ASC", GetSQLValueString($colname_sections, "text")); $query_limit_sections = sprintf("%s LIMIT %d, %d", $query_sections, $startRow_sections, $maxRows_sections); $sections = mysql_query($query_limit_sections, $santiago) or die(mysql_error()); $row_sections = mysql_fetch_assoc($sections); if (isset($_GET['totalRows_sections'])) { $totalRows_sections = $_GET['totalRows_sections']; } else { $all_sections = mysql_query($query_sections); $totalRows_sections = mysql_num_rows($all_sections); } $totalPages_sections = ceil($totalRows_sections/$maxRows_sections)-1; $queryString_sections = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_sections") == false && stristr($param, "totalRows_sections") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_sections = "&" . htmlentities(implode("&", $newParams)); } } $queryString_sections = sprintf("&totalRows_sections=%d%s", $totalRows_sections, $queryString_sections); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[url="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd[/url]"> <html xmlns="[url="http://www.w3.org/1999/xhtml"]http://www.w3.org/1999/xhtml[/url]"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Olivia Santiago - Fine Artist</title> <link href="img/santiago.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> <!-- function oliviars_popup(oliviars) { var w = 600; var h = 600; var l = Math.floor((screen.width-w)/2); var t = Math.floor((screen.height-h)/2); window.open(oliviars,"", "width=" + w + ",height=" + h + ",top=" + t + ",left=" + l + ", status=no, menubar=no, toolbar=no, scrollbar=no, directories=no" ); } //--> </script> </head> <body> <?php if ($pages[0] == "links"){ // visualizza i link ?> <div id="os_body"> <div id="os_top1"><ul><li><a href="?">Home</a></li> <li><a href="?p=portraits|1" <?php if ($pages[0]=="portraits") { echo "class=\"a_active\""; } ?>>Portraits</a></li> <li><a href="?p=landscapes|1" <?php if ($pages[0]=="landscapes") { echo "class=\"a_active\""; } ?>>Landscapes</a></li> <li><a href="?p=still-life|1" <?php if ($pages[0]=="still-life") { echo "class=\"a_active\""; } ?>>Still life</a></li> <li><a href="?p=bio|1" <?php if ($pages[0]=="bio") { echo "class=\"a_active\""; } ?>>Bio</a></li> <li><a href="?p=events|1" <?php if ($pages[0]=="events") { echo "class=\"a_active\""; } ?>>Events</a></li> <li><a href="?p=links|1" <?php if ($pages[0]=="links") { echo "class=\"a_active\""; } ?>>Links</a></li> </ul> <img src="img/tread.jpg" /> </div> <div id="os_page1"> <div id="box_text"> <div id="text"> <?php // begin Recordset $query_links = sprintf("SELECT * FROM link ORDER BY ordine ASC"); $links = $santiago_ado->SelectLimit($query_links) or die($santiago_ado->ErrorMsg()); $totalRows_links = $links->RecordCount(); // end Recordset ?> <table class="os_table_links"> <tr > <td height="20" ></td></tr> <?php while (!$links->EOF) { ?> <tr > <td height="35" ><p><strong><?php echo $links->Fields('descrizione'); ?></strong><br/><?php if ($links->Fields('url') != "") { ?><a href="<?php echo $links->Fields('url'); ?>" target="_blank" ><?php }?><?php echo $links->Fields('url'); ?></a></p></td> </tr> <?php $links->MoveNext(); } ?> </table> </div></div> </div> <div id="os_bottom"> <div id="pages"> <div id="page_previous"><?php if ($pageNum_sections > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_sections=%d%s", $currentPage, max(0, $pageNum_sections - 1), $queryString_sections); ?>">previous</a> <?php } // Show if not first page ?></div> <div id="message"><a href="[email="eusebiodecristofaro@gmail.com"]mailto:eusebiodecristofaro@gmail.com[/email]" class="credits" >Web Art - [email="eusebiodecristofaro@gmail.com/a/div"]eusebiodecristofaro@gmail.com</a></div[/email]> <div id="page_next"><?php if ($pageNum_sections < $totalPages_sections) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_sections=%d%s", $currentPage, min($totalPages_sections, $pageNum_sections + 1), $queryString_sections); ?>">next</a><?php } // Show if not last page ?></div> </div> </div> </div> <?php } elseif($pages[0] != ""){ ?> <div id="os_body"> <div id="os_top1"><ul><li><a href="?">Home</a></li> <li><a href="?p=portraits|1" <?php if ($pages[0]=="portraits") { echo "class=\"a_active\""; } ?>>Portraits</a></li> <li><a href="?p=landscapes|1" <?php if ($pages[0]=="landscapes") { echo "class=\"a_active\""; } ?>>Landscapes</a></li> <li><a href="?p=still-life|1" <?php if ($pages[0]=="still-life") { echo "class=\"a_active\""; } ?>>Still life</a></li> <li><a href="?p=bio|1" <?php if ($pages[0]=="bio") { echo "class=\"a_active\""; } ?>>Bio</a></li> <li><a href="?p=events|1" <?php if ($pages[0]=="events") { echo "class=\"a_active\""; } ?>>Events</a></li> <li><a href="?p=links|1" <?php if ($pages[0]=="links") { echo "class=\"a_active\""; } ?>>Links</a></li> </ul> <img src="img/tread.jpg" /> </div> <div id="os_page1"> <?php if ($totalRows_sections > 0) { // Show if recordset not empty include("modules.php"); } ?> </div> <div id="os_bottom"> <div id="pages"> <div id="page_previous"><?php if ($pageNum_sections > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_sections=%d%s", $currentPage, max(0, $pageNum_sections - 1), $queryString_sections); ?>">previous</a> <?php } // Show if not first page ?></div> <div id="message"><a href="[email="info@oliviars.it"]mailto:info@oliviars.it[/email]" class="footer_text">info@oliviars.it</a></div> <div id="page_next"><?php if ($pageNum_sections < $totalPages_sections) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_sections=%d%s", $currentPage, min($totalPages_sections, $pageNum_sections + 1), $queryString_sections); ?>">next</a><?php } // Show if not last page ?></div> </div> </div> <div id="os_copyright"> Copyright © 2008 by L. Olivia Santiago - All rights reserved</div> </div> <?php } else { ?> <div id="os_body"> <div id="os_top0"><img src="img/olivia-name-home.jpg" alt="Olivia Santiago" width="850" height="130" border="0" /></div> <div id="os_page0"><a href="?p=portraits|1"><img src="img/olivia-img-home.jpg" alt="enter" width="850" height="400" border="0" /></a></div> <div id="os_bottom"><a href="?p=portraits|1" class="footer_text">enter</a></div> </div> <?php }?> </body> </html> <?php mysql_free_result($sections); ?>
-
Php question...
Hey Pat, thanks for replying. Geez, what a pain. This site is hosted by Aruba.it. After much run-around I was able to get access to the database, however, now that I'm there I have no idea what to do After completing the home page, I need to make a minor change to each page on the site (updating the navigation bar). If each page is being generated by the database, how do I go about that? Thanks for any tips and tricks!
-
Php question...
I've been asked to update the home page for this site. After accessing the site via ftp, I'm a bit confused as to the structure. I can see that I modify the html contents of index.php. However, since the site links will be updated I will also need to modify the links on other pages throughout the site. Herein lies the confusion... I can't seem to locate the pages within the ftp contents. The first portraits page is listed as follows: oliviars.it/?p=portraits|1 The second portraits page: oliviars.it/index.php?pageNum_sections=1&totalRows_sections=2&p=portraits|1 What exactly is that indicating? I don't see any indication of a portraits|1 anywhere in the ftp contents. This also goes for landscapes|1, still-life|1 etc. Any ideas? Thanks!
-
Annoying white box
Geez... Are you kidding me!? Well, NOW I feel stupid. I had changed that previously to black but must have over-written it with the original. Thanks so much for pointing out the obvious!
-
Annoying white box
Hi - Thanks for responding. Unfortunately it did not eliminate the issue
-
Annoying white box
I've put together a simple, single page css-based site. Around the site content there is an annoying white box (The site colors contain no white). I'm pulling my hair out trying to correct this! Would you be so kind as to take a look and let me know what I'm doing wrong? Thanks!!
-
Multiple language website: Most efficient methods
I have a client who is interested in having built a 4 language travel website. Regular content updates will also most likely be needed for each language. What is the most efficient method for creation and maintenance? Thanks for any comments / suggestions!!
-
Deny access to mp3 using htaccess
Can you elaborate on that a bit? What would be the different ways that I might embed the mp3? To clarify a bit on my MySpace comment; In MySpace I am able to mouse-over and listen to my clients music without the RealPlayer "Download This Clip" popup appearing. On the site I'm building my embedded player offers "Download This Clip" option, which I don't want. My client tells me that the MySpace player offers the ability to enable or disable downloads. Having that option disabled, I assume, is why the popup does not appear.
-
Deny access to mp3 using htaccess
I believe that is probably true, however, I would like to globally deny download access, no matter the individual computer setting. This is especially true for RealPlayer, which seems to come installed on a large percentage of computers. I know that on MySpace.com, which has a huge number of muscians, there is an option to deactivate download possibilites of their standard mp3 players.
-
Deny access to mp3 using htaccess
Hello! I am building a site for a musician. I've embedded an mp3 player on the main page, which works fine. The trouble lies in the fact that when you mouse-over each song a RealPlayer popup is activated asking if you would like to download the song. This is an option and distraction I do not want. Research tells me that the cleanest solution is to block access using my .htaccess file. However, while I was able to block the popup by doing so, access to the music was blocked, as well, and the songs would not play. Does anyone know how to resolve this issue? Or maybe another, better alternative? Thank you!