-
Posts
796 -
Joined
-
Last visited
-
Days Won
1
Posts posted by phppup
-
-
Do I need to have an internet connection at that point?
-
Not everything is included. I found a thread on WAMP that guided me to 4 updates to resolve an MSVCR110.DLL error.
Meanwhile, I think I finally got it loaded, but nothing occurs when I hit the WAMP desktop icon (except a message asking if I want to allow the program to make changes to my computer).
What should my next steps be to validate the install and utilize the download?
-
Trying to get WAMP working.
Apparently there are some Microsoft updates required.
What is the difference between WAMP and XAMPP?
Am I right in saying that XAMPP is more advanced? Has more user options?
Thanks for the help.
-
Let me re-phrase: I want to be able to test code and forms on my laptop WITHOUT using an internet connection.
No cable. No WiFi. No connectivity.
Just me, the laptop, and the code.
Is there a simple process so that I can I install PHP and MySQL for this purpose?
-
I got a new laptop running Windows 7 and wanted to develop some PHP coding for test purposes.
I want the data I test to go into MySQL.
What do I need to do and where can I get the appropriate downloads to get started with the most basic of set-ups?
-
Looks like I'd better get some sleep before jumping into this one. But thanks for the help.
-
Let me start bty saying that I'm not looking for anybody to write the code for me, but I am considering a function and am not sure of the best approach (or whether something exists in either PHP or MySQL that will handle this directly).
Note: I have not developed the database for this project yet, so perhaps there are clues or shortcuts at that level.
What I am intending is to track orders. The items on these orders (let's say pants, shirts, socks and hats) will be input to a central database under a customer name with associated customer information.
The datbase will be used to provide item quantities so that inventory issues can be addressed.
Here's the twist. Each item may be handled by a different department. In fact, if someone wants 4 hats it will require 4 'tickets' (one for each) to be processed. What I want to do is include a statement on each ECHOed ticket that would state "This is item number x of y pieces for this order."
The ordering of the count can be arbitrary, as long as I can provide an accounting of items beginning with the number 1 for each customer.
So, do I use the COUNT function, a formula with an n+1, or should I be thinking in terms of longwritten IF statements (probably the wrong approach/more difficult path -- which explain the reason for this post).
Your guidance is greatly appreciated.
-
Not trying to be rude. Just wanted to thank those whose help was informative, and indicate how another response, while well intentioned, really did nothing in the way of guiding me to the solution I was seeking.
Jes has aided me in the past, and I appreciate that. But sometimes the answers without explanations are more confusing to US with the questions. Just as questions without info can be frustrating to the more advanced.
There is a talent to conveying the lesson, and not everyone who has the answer can adequately teach it.
I salute those that can, and do. And express this so that we can rise to a higher level in the forum.
No ill intended.
-
When Jesirose said: "Yes, and you've already been told that in this thread, with an explanation of how" a kitten MUSt have died, as it was as effective as posting "it doesn't work."
Thanks for the explanation Scootstah.
The BOLD typeface was a real eye-opener too! LOL
Hope you've been well. Thanks again!
-
See, I always learn something here... even if it's not what I intended.
So I get it about the design, BUT what I REALLY meant to say was:
Is there a REAL difference between using:
select * from mytable .. blah blah blah
versus
select COLUMN_NAME from mytable .. blah blah blah
if I am then going to use something along the lines of:
ECHO COLUMN_NAME
and essentially get a print out of the data for the single item.
I know the result wil be the same, but is there a REAL reason to concern myself or use one method rather than the other?
-
Let's clarify:
I have a table with columns that cover items of men's clothing. There's a column for each item, everything from shoes, socks, to hats and turbines. Each item will receive a value from zero to 99,999 when inventoried.
So NOW, if I want to quiery the total of t-shirts, and then the total of boxer shorts, etc. will I NOT get the same result whether I use:
select * from MYTABLE.... order by pants
versus
select pants from MYTABLE... order by pants.
In either instance I believe I am ultimately filtering the results to a specific item. So am I better off using the asterisk and then filtering down the result, or by simply using the specific column from the start.
I assume the latter is best, but wasn't certain if it REALLY makes a difference.
-
Thank you Psycho... for the informative and educational response!
-
Perhaps I wasn't specific enough.... let me re-phrase:
If I need data form ONLY one COLUMN in my table, does it make a difference which way I write the quiery?
I know the result will be the same, but are there other reasons to use one method over the other??
-
Is there a REAL difference between using:
select * from mytable .. blah blah blah
versus
select COLUMN_NAME from mytable .. blah blah blah
I know the result wil be the same, but is there a REAl reason to concern myself or use one method rather than the other?
-
OKAY! I got it. Thanks again.
The <BR> was there because the info was originally printed out within a sentence.
(ie: Order number '$id' for '$customer name' contains '$quantity' of this item.)
I needed the HTML breaks to avoid a running sentence.
When I switched the data into a table, the BR's go overlooked.
Thanks for all the assistance.
-
Sounds like that should do it, huh? Thanks for the solution. It seems sensible.
I guess the PHP digests the <BR>s first, and then after they've been regergitated, it spits out the table that I wanted.
Thanks again!
-
I want to print out the findings of my query in a table format. Yet when I include the <table> tag the information drops to a position half way down the browser page. Is there a PHP reason for this?
<?php
**connection info***
echo "TITLE HERE";
echo "<br>";
$queryC = "SELECT * FROM MYTABLE WHERE pants>0 ORDER BY pants,id ASC";
$resultC = mysql_query($queryC) or die(mysql_error());
echo "<table border='1'>"; //the TABLE TAG is FORCING the display to the BOTTOM of the PAGE
echo "<tr> <th>Order</th> <th>Customer</th> <th>Amount</th> </tr>";
// Print out result
while($row = mysql_fetch_array($resultC)){
// use the DOT to CONNECT html in QUOTES and PHP-terms
echo "<br />";
echo "<tr><td>";
echo "#" . $row['id'] ;
echo "</td><td>";
echo $row['customer'];
echo "</td><td>";
echo $row['pants'] ;
echo "</td></tr>";
echo "<br />";
}
echo "</table>";
mysql_close();
?>
-
Can anybody clarify the usefulness of "AS" and elaborate on how it operates.
If I select a 'bananas' AS 'yeelow fruit' will it change the TITLE in the table? Or the table that is being viewed?
If I dump a list of 'FRUITS' into and HTML table, will using AS rename each column for me, or is that handled by MY coing of the HTML table?
-
I had a similar problem months ago.
I don't recall how I solved it other than ignoring GoDaddy completely.
ANd there HELP is of NO HELP at all.
-
And what about the SQL statement?
How should that be modified?
-
I'm trying to understand the mechanics of PHP.
Suppose I have a form that collects these three values
$firstname = $_POST['firstname'];
$middleinitial= $_POST['middleinitial'];
$lastname= $_POST['lastname'];
and I want to insert EVERYTHING into ONE FIELD in my table called FULL_NAME.
What is the methodI should use to COMBINE the values shown above?
Do they need to be listed individually in the statement below?
What if I want a final entry to contain fiirstname (space) middleinitial (period) (space) lastname all in one field?
$sql = "INSERT INTO myTable ( FULL_NAME ) VALUES ( $firstname,$middleinitial,$lastname )";
$result=mysql_query($sql);
Would the $SQL line look like this? Or am I totally off track?
-
I currently have a Javascript placed at the top of the same file as my HTML form.
Now I need to run the file as PHP, and was wondering what the proper protocol and best practice is for the JavaScript (which does some client side validation).
Can I leave it as is, at the top of the file after changing the extention to PHP.
If I put it in a seperate file, should I call it as a JavaScript or as an INCLUDE file.
If I INCLUDE it, should the INCLUDE be a PHP file (that contains the JS, or a JS extention.
Does any of this make a difference, or will any method work, leaving it to personal preference?
-
OKAY... so i was 'playing' the other evening, and i DID add a 'CLASS' to one button. After doing this, it accepted the size changes PERFECTLY.
I have to assume the group would react similarly.
So why will they respond in the CLASS (and in the tagline) but NOT when cirected by TYPE? Why does THAT work on the webpage (see above for the link) but NOT in my own browsers (which I attempted on two versions of IE running two different operating systems??
Any answers?
(could it be because I'm on the east coast?? LOL)
-
Hey Drummin. Nope, it won't work.
I've concluded that the server will NOT run PHP in an HTML file.
(i believe this is one of the reasons I got roped into learning full blown PHP in the first place... LOL)
It appears INCLUDES are also suspect. Although I've seen some articles that blame IntExplorer too.
I suppose I'll survive with just PHP files (but I'd have liked to see them as HTML at home, where my PC isn't running PHP.)
MySQL / PHP set-up
in MySQL Help
Posted
There's NO icon on the taskbar, but there is one with the "USB removal" button etc.
Tried opening the index page from the WWW folder, but it didn't display properly. It simply showed all the PHP coding, but did NOT translate it into functional end-product. My assumption is that something is missing, but not sure what or where.