Laterooms xml

[nick-harper]

I am not entirely sure people will want to share the code they have spent time researching and creating. There are a few scripts available to buy though I think.

These are the steps:

• Get the info into the db from either CSV or XML (whichever is easiest)
• Display Data from mySQL Database on Web Page
• Make a Website / Structure a site around the database and call the information where needed

Tigzag is a good place to start for PHP. You should learn the different parts of PHP to makeup the project / site like displaying data, updating data, sorting data.

 

[chippyb]

Right well thought I would do a quick test to see if i could get something to happen so I put the php could into a test.php page with the html of the other page but no css and nothing happened

 

[chippyb]

cant import the csv data either as the file is 44mb and the max i can do is 8mb!

 

[expertc]

I did run a quick test. Imported hotels in Bath into my development Shopperpress site just to test. Site is not live yet, nothing (!) is done about it therefore you can see the sample results here 'discount hotel rooms (dot) org (dot) uk'. Remove the spaces and make it into proper url. I don't want it indexed yet

 

[chippyb]

im not using wordpress, i can see it is easy if i am but im not

 

[expertc]

im not using wordpress, i can see it is easy if i am but im not

Don't worry. WP is just a code + database. If you can code every page manually you can do the same in html + php. This test run is to show how data is imported then pulled of MySQL and formatted by simple code and css.

 

[Retired_member41]

I know everyone is helping Ryan here, but surely someone who says they can hand code html and css can get his head around this?

Its like pulling teeth.

Sorry if it seems I'm being unfair, but things don't add up and very rarely if ever, do you actually say thank you for the help your receiving??

Still worth it though as I've learned something

 

[chippyb]

If you notice alot of my posts have said thanks in them, and once again thanks!! I am really pleased all these people are coming back to me on this, do you want me to list some lists to prove I can hand code?

anyway, Right I have got the data to display using the code admin posted, but changed to suit my needs and using my id, but as people said it is slow so how do I go about putting into mysql and calling it from that?



Thanks

 

[nick-harper]

You will need to start with the basics.

How to Insert Data into mySQL
How to Display Data into mySQL
How to Sort Data from mySQL
How to Update Data in mySQL

 

[chippyb]

next and final question! lol using that php code i am use how do I style it in divs how each one is in a small container say 200px by 200 if you know what i mean, what i tried didnt work
Thanks

 

[nick-harper]

You just echo the PHP Variables into the DIV

<div class="hotelnamebar">
<?php echo $hotelname; ?>
</div>

You really should just read up on some basic PHP, it will help a lot.

 

[chippyb]

ha that was what i was trying, and it didnt work no it is, ok thanks guys

 

[nick-harper]

You need to have a variable to echo out. It also needs to be a .php file that you are working with.

If the variable is empty it wont appear.

Start off trying this

<?php echo "Can you see me?"; ?>

 

[chippyb]

I have the list of hotels displayed thats not a problem, im just trying to style each hotel now into its own styled section so i can display them in about 3 or 4 a row and not just a basic list of text

 

[nick-harper]

Just find where they are being echoed out and put the style around them. Simple

 

[expertc]

I have the list of hotels displayed thats not a problem, im just trying to style each hotel now into its own styled section so i can display them in about 3 or 4 a row and not just a basic list of text

There is absolutely no difference what to style static code or php echo's and print's. Same div and class is used. Just wrap them around your code.

 

[chippyb]

ok thank you guys so much I know this isnt pretty but this is my first test to get the sort of thing im after, http://www.london hotel offers.org.uk/ Templates/test.php but it works, havent put it in my data base let this is just the live feed but it is now working,

Thank you guys im sure I can take it from here lol

 

[expertc]

Well done! In the real-life situation limit parsed data to about 10-12 items per page otherwise it is going to be slow.

 

[grantw]

Well done! In the real-life situation limit parsed data to about 10-12 items per page otherwise it is going to be slow.

Looks great as it is, especially like the green. I'd leave it like that

Grant

 

[chippyb]

Yea i am going to do that anyway, need to learn how to put the xml in the database now, so it updates as well and get it to work start from the begining again now