[Setting up a DNS server]

I was able to get my Windows DNS server setup with this tutorial:

 

http://alex.charrett.com/bind-on-windows-mainmenu-3

[Searching in html table]

Are you looking for something like this:

 

http://phpsnips.com/snip-94

[image path issue]

We will probably need to see more than that. Cant really help you without the exact line

[image path issue]

you would have to show us how you generate the img tag.

[image path issue]

have you looked at the src in the img tag in the html? Is it pointing to the correct location?

[Can you set a timeout for your script]

If your going to do it via php, you should do it using curl, curl has built in timeout settings, if you do set_time_limit that will timeout YOUR webpage where as curl will only timeout the connection to twitter.

[How to extract and display the datetime from the MySQL DB corectly?]

Third your using the wrong datetime format in the database.

 

It should be:

 

YYYY-MM-DD HH:MM:SS

[Can you set a timeout for your script]

you can do it via javascript.

 

<div id="twitter_update_list"><!-- Your Latest Tweet Will Display Here Once Loaded --></div>
<script type="text/javascript" src="//apis.jssnips.com/twitterblogger/latest.js"></script>
<script type="text/javascript" src="//twitter.com/statuses/user_timeline/my_user_name.json?callback=twitterCallback2&count=1"></script>

 

replace my_user_name with your twitter username

[duplicated rows in DB]

The best way to stop duplicates, is to add a unique index on the table.

 

then when you do an insert into that table:

 

insert ignore into ( ... ) values ( ... );

[last insert ID's]

@Little Guy:  Are you trying to resolve a problem you know exists? or are you just trying to cover all your bases?

 

One of our tables has about 225,000 (~2/sec) inserts per day, and every so often we need to insert 2+ records, so instead of doing one at a time to get the insert ID's it would be nice to do it all at once.

 

So with about 2 addition inserts per second, you can almost guarantee that while I am doing my mass insert someone else will be wanting to insert 1 or more rows as well. So if the other person doesn't get locked out, he could insert halfway through my insert, and I will then have bad historical data.

 

Does that answer your question?

[mysqli_stmt_bind_param like mysql_real_escape_string?]

Okay thanks, that is what I though!

[mysqli_stmt_bind_param like mysql_real_escape_string?]

When using mysqli_stmt_bind_param (object or procedural), does this also act like mysql_real_escape_string? Does it prevent SQL Injection?

 

http://us.php.net/manual/en/mysqli-stmt.bind-param.php

 

It seems like I don't have to do anything else, but maybe I am wrong?

[Ubuntu Slow Startup]

I hear people say "linux mint" is a better distro...

[last insert ID's]

I keep hearing that doing this is bad though, because someone could do an insert while my insert is only half way complete. But it seems like some of you are disagreeing with that.

 

You can retrieve the most recent AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not affected by another connection which is also performing inserts.

 

But Barand already told you this.

 

Right but if I get auto_id 10 on one connection, and another connection gets auto_id 11 and we each insert 5 rows, I am not going to get all 5 of my inserts, I will get mine and someone esle's. since supposedly the table doesn't get locked on inserts, but maybe that is Storage Engine Specific...

[Ubuntu Slow Startup]

I just installed Ubuntu 12.04, and when I start it, it takes forever to load anything. But when I start it in "recovery mode" everything runs very snappy. Why is it so slow in normal mode?

[PHP 5.4]

I have 5.4 and mysql works just fine

[last insert ID's]

Going off Illusion:

insert into table_a (col1) values ('one'), ('two'), ('three');
set @first_iid = (select last_insert_id());
set @last_iid = (select (row_count() + @first_iid) - 1);

 

That should get us our first and last insert id's, and assuming the table increments by one, you can calculate all the rows inserted by basic math.

 

I keep hearing that doing this is bad though, because someone could do an insert while my insert is only half way complete. But it seems like some of you are disagreeing with that.

[PHP Mysql Query]

#2 has wild car operators in them, and the equal sign comparison doesn't support wild cards so, that is what it is searching for something that has % on the ends of what $program_name is. remove them and you should get what you are looking for

[prevent bypass page in php?]

when the user goes to a page check the session this should be an int for the page/step number they are on. then you just would compare their session to the step number. if the step is bigger than the session number send them back to their session number's step. once they complete a step successfully increment the session number.

[Exporting data to a .sql file]

does the user on the database have enough permissions to import the dump file?

 

also remove the table name from the command your running it is already in the dump file. you also have too many quotes.

 

exec("mysql --user=... --password=... --host=... $database < /location/$filename.sql");

[last insert ID's]

with a single insert query, the next insert waits, till the previous one is done before it can go, I would assume that this is the same thing that way you wouldn't have the alternating inserts. I am not sure though.

[last insert ID's]

is it possible for two members to run this, and they are inserted every other?

 

for example we both insert 6 records (total of 12) and it looks like this for the insert:

 

me

you

me

you

me

you

..

..

and so on

 

If that happens, then this won't really work will it?

[last insert ID's]

I know there is last_insert_id() but it only gets one of them, I would like a table that returns all of them (I believe what your saying).

[last insert ID's]

Lets say I want to insert into a table using one query, like this:

 

insert into test (name) values ('monkey'), ('baseball');

 

what can I do to get both of the insert ids?

[Best route for SEO]

Instead of using php to populate an array, why don't you just place it into hidden HTML Div's then when you want to show one show hide all the divs then show the one you want by toggling css's "display" property.