[php select box from database]

Hey guys i have a products site and i put an edit product page , i need to put in a form of select box the database info but highlight the result in the table..

 

 

ok so lets say product car

 

name

id

type

brand ---> select box to edit the brand (select * from Brands) but incase he does not want to change that info i need the default to be the info stores already?

 

brand Honda -->select box highlight Honda 

 

this is the select i have 

div class="form-group">
    <label for="exampleInputName2">Brand :  <? echo $row['Brand'] ?></label>
   
    <select name="Brand"> 
    <?php 
while ($row2 = mysqli_fetch_array($result2))
{
 echo "<option value='".$row2['Name']."'>".$row2['Name']."</option>";
}
?>   

[insert text from text box as is?]

interesting. thx for the info i will read up on it.

[insert text from text box as is?]

so the output would be

$string = ".echo row['description'];.";
echo nl2br($string);

[insert text from text box as is?]

Hey guys i have a for to upload for a car dealership i did ,in the form there is a text box for descrption.

 

the guy wants to be able to insert a description like:

 

...........................

 

this is a car test

 

.features one

.features 2

.......

 

this car is fully equipeed...

 

..........................

 

but now the form insert in the database all messt up it becomes one text...

 

 

is there a way to insert it in the database as he puts it?

[PHP Warning: exec() has been disabled Alternative?]

ya i found a way to install apache server in it and access it remotly.but the gpio is not activating..will figure that part..thx!

[PHP Warning: exec() has been disabled Alternative?]

i sent out a request .. in the cpanel i only have basic php ini values that i can mod....

[PHP Warning: exec() has been disabled Alternative?]

i don't think i have access...i will check the cpanel to see

[PHP Warning: exec() has been disabled Alternative?]

Hey guy's i doing a Rasperry Pi garage door app and got this code in a tutorial:

 

$q=$_GET["q"];

 

if(isset($_GET['q']) && $_GET['q'] == 1) {

error_reporting(E_ALL);

exec('gpio write 7 0');

usleep(1000000);

exec('gpio write 7 1');

echo" garage is Open";

} 

 

i modified it to return a response.

 

but i get an error file from server

 

PHP Warning:  exec() has been disabled for security reasons in /home/techker/public_html/Garage/getcd.php on line 15

 

is there an alternative or way around this ?

[Automated Script]

ok let me restart..sometimes i tend to right what i think in my own words..lol

 

 

ok i extracted usernames and emails from databases.

now we installed a new script and we want to import the username and emails in that main database.

so this script it needs the main user table to have username and email a the date.

once that is done 

user_profile
user_count
user_Activity

needs to have the id generated from user table inserted.

[Automated Script]

the database is new.so all the emails will be unique.

 

i have about 1200 emails..lol

 

so first step is insert into the user database

 

the select user id from the database and insert into the profile and others..

 

but i need to add them individually..not all in one table.

[Automated Script]

Hey guy's my body has a few social media site and want's to merge them all in one.

i extracted all the username and emails from all DB

i need to insert the username and email in the new database and once that is done take the userID an isert it in 4 other databases

so the first step is user then the others are for profiles and settings..if i don't do it the user lands on a 404 since the profile was not created..

is there a way to do this automated..

i inserted the usernames in Database Dump on the same server

[order in catalog]

ya i think i need to site down with my body on this..lol

 

the drag and drop is a good idea..just need to make a database that will store the order that he sets it with an id.

 

then extract by order by..

 

 

Hey thx for the help guys!

[order in catalog]

true i can always use update..

 

how can i auto increment a field starting from 1..

 

and if you delete the product it needs to reset the fields..cause if i delete the order 3 there will be missing a 3 in the order..

[order in catalog]

can you correct this?

 

 

 
$num= $_POST['num'];
$CheckNum = mysql_query("SELECT Order from Products WHERE Order = '$num'");

while($test = mysql_fetch_array($CheckNum))

if ($test ) {
echo "Is not valide";
}

[order in catalog]

there should be a way to warn before he submits?cause if he makes like 3 errors it can take a long time to add a single product..

 

maybe a select box that shows only the numbers not taken?

[order in catalog]

but how can i warn the user ?

[order in catalog]

Hey guy's i made a small catalog style for my body's shop,in the admin he inserts and deletes products.

 

but he would like to order the products the way he wants to,not by Id or ASC desc...

 

so i added a field order inserts 1 to 10 lets say.

 

so how can i do it so first there is not replicates and second when i do my query how can i make it order by numbering 1 to 10..

[wysiwyg textarea]

the textare is for a dealership script im doing for my body..just to add cars..

 

see,so i would change the class for WSYIWYG?but then the others?

<code>

 <label>SHORT DESCRITION</label>

               <textarea name="Description_short"  cols="55" rows="4" class="text-input textarea" ></textarea>

            

         <label>SHORT  FR</label>

  <textarea name="Description_short_FR"  cols="55" rows="4" class="text-input textarea" ></textarea>

           

        <label>FULL DESCRIPTION</label>

            <textarea name="Description_long"  cols="55" rows="6" class="text-input textarea" ></textarea>

<label>FULL DESCRIPTION FR</label>

  <textarea name="Description_long_FR"  cols="55" rows="6" class="text-input textarea" ></textarea>

 

</code>

[wysiwyg textarea]

Hey guys,i noticed that when i try to add more then one ID:wysiwyg on my  textarea it only works on one..

 

is there a way to have lets say 3 wysiwyg textarea??

 

do i need to add a class wysiwyg2  wysiwyg3....