Using Database Info in a Form Options

[stub]

The "domain" was already being displayed in the form. I'm trying to extract the "price" from the database and display that also in the form. I'm not an expert with CSS. So don't laugh if the syntax is wrong.

CODE

<div class="3u"><input type="text" name ="domain" placeholder="Domain" value="<?php echo preg_replace('/[^a-zA-Z0-9.-]/', '', $_GET['domain']); ?>"/></div>
<div class="3u"><input type="text" name ="price" placeholder="Price" value="<?php echo preg_replace('/[^a-zA-Z0-9.-]/', '', $_GET['price']); ?>"/></div>

This post has been edited by stub: May 3 2016, 07:24 AM

[Christian J]

This is about PHP, not CSS, so I moved the thread.

[Christian J]

$_GET just extracts the URL's querystring. Does the latter contain a "price" value?

Furthermore, to acess the database you need the PHP script to perform a database query (which is not the same as a URL querystring).

[stub]

Yes there is a price value for the domain in the database. What would the database query string look like? Where should it appear? Immediately before the lookup?

This post has been edited by stub: May 3 2016, 04:55 PM

[stub]

OK. I guess the URL query string is coming from the fact that the domain name is being sent the domain name to the form by the link the visitor has used to get to the form. So no need for a database lookup. Yes/No?

So I'm guessing I need to lookup the price of that domain in the MySQL database, and put it in the price box. How to do that?

This post has been edited by stub: May 4 2016, 06:48 PM

[Christian J]

OK. I guess the URL query string is coming from the fact that the domain name is being sent the domain name to the form by the link the visitor has used to get to the form. So no need for a database lookup. Yes/No?

Not sure I understood the above, but an ordinary link can contain a querystring. How that link is created is the problem.

So I'm guessing I need to lookup the price of that domain in the MySQL database, and put it in the price box.

Yes.

How to do that?

Does your existing PHP script contain any MySQL queries, e.g. for the "domain" INPUT field?

[stub]

The problem is I don't know what I'm looking for. Could you please give an example of what it might look like?

This post has been edited by stub: May 5 2016, 10:46 PM

[Christian J]

Here are a few examples: http://php.net/manual/en/mysqlinfo.api.choosing.php

But if you have no experience with this, you really should start learning the basics first. If you try to hack existing code, maybe you'll accidentally break the database, or open it up for exploits.

[stub]

Thank you. I don't have anything like that in my page